[pilot-db-list] problem converting from MobileDB->CSV format.

[Mark D. B. <md...@em...>]

Greetings,

In attempting to convert a database modified by the MobileDB v2.1
application, I ran into a problem where I was getting the error
message.

'test1.pdb: maximum number of fields exceeded'

At the time of the error, the value of field is 20 and the value of
getMaxNumOfFields() is 20. Making a small change (below), seems to
have worked around the problem for me. (The odd thing with this data
is that no record actually has more than 14 fields.) A copy of the
test1.pdb to test this one is available via

  http://www.employees.org/~mdb/mobiledb-data/ 

as the test1.pdb (55k) file.

The next problem I have run into is with a database created directly
on the Pam using MobileDB v2.1. The pdb2csv error returned is 

'test2.pdb: data record has the wrong number of fields'

A copy of the test2.pdb to test this one is available via

  http://www.employees.org/~mdb/mobiledb-data/

as the test2.pdb (1k) file.

I am not sure of the correct fix for the test2.pdb case.

If you have any suggestions, I'd appreciate hearing about them.

	Thank you,
	-- Mark

--- palm-db-tools-0.3.2/libflatfile/MobileDB.cpp.orig	Sat Oct 14 22:45:23 2000
+++ palm-db-tools-0.3.2/libflatfile/MobileDB.cpp	Sun Jun  3 01:29:04 2001
@@ -213,7 +213,7 @@
         if (field == 0xFF) break;
 
 	// Make sure that we don't go beyond the maximum number of fields.
-	if (field >= getMaxNumOfFields())
+	if (field > getMaxNumOfFields())
 	    throw PalmLib::error("maximum number of fields exceeded");
 
 	// Expand the fields vector if this field goes beyond the end