
Trouble loading comma delimited records
I'm trying to import comma delimited data into Btrieve files. There are
164 string fields in each BASIC record. The records are 500 to 800
bytes long. All fields are surrounded by
double quotes. I created a Process in my app and embedded code for each
TakeRecord to put the BASIC data fields into the fields in two Btrieve
files and ADD or PUT the records. The problem is that the process is
not reading every record. It's reading every 11th or 12th record. If I
run it over and over it picks up different records. I've verified the
record structure so I'm not crossing record boundaries (and if I did, I
think there would be pieces of other records in the good ones). It may
have something to do with the Btrieve driver but I can't figure it out.
However, at first I was using a 32bit Btrieve Server client and getting
corrupted data. Now I'm using the 32bit Btrieve Workstation client and
getting the behavior described above. Also the BASIC record declaration
has a group dimmed 20 with several fields in it. Clarion didn't balk at
it but I remember some problem with that years ago.
Any suggestions are appreciated,
Brad Kunkel