>Subject: Question about syncing comma separated file
>From: "Dean Rochester" <[EMAIL PROTECTED]>
>Date: Wed, 16 May 2001 17:28:50 -0400
>I have a database application I am writing and the data comes
> to the Palm device as a comma separated file.
>The problem I have is that the columns of data is not the
>same each time. Starting with the 3rd column of data, there
>may be as few as 5 more columns and as many as 50 or more.
>There is no way to set the max number of columns.
> The reason I am asking this is because how do I know what
> the start of the next column field is. I set the offsets for
>the starts of each field in the row of data by using defines.
>I do not know how to do this when the number of columns changes.
One of your problems is you have what database gurus call an
"unnormalized database"
I suspect your life would be a lot easier if this data was sent as two
files each with a predicable set of fields:
1) Location file:
Name, Location
2) Asset file: (this looks like an asset tracking application)
Location, asset description, value
Roger Stringer
Marietta Systems, Inc.
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palmos.com/dev/tech/support/forums/
