Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Low Level Files
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00357441
Message ID:
00357447
Views:
17
>>Suprisingly, when I added code to to insert these variables into a dbf, the code makes one pass and stops. (The file I'm parsing is a little over 6 meg) When I comment out the INSERT INTO section of the code, it works fine.
>>
>>The main loop is centered around a DO WHILE NOT FEOF() loop. Is is possible I'm causing a problem with work areas when I perform the INSERT INTO?
>
>That's strange, all right. Your condition definately tests FEOF() and not EOF() (an easy mistake when it is late <g>)? The table's record pointer doesn't have any effect on a low level file handle. And the LLFFs don't use a work area.
>
>Are you using a UDF in the value list of the INSERT INTO command? Or do you have row or field validations that call a UDF? If so, something may be changing the value the file handle that you test with FEOF( ).
>
>-Bob

Okay, I win the stupidest dog trick of the year award....

One of the fields I was inserting into was named INVOICE. To be honest, it slipped past me because it was a field name and not the name of a variable I was using. (Still not sure why that mattered, but apparently it did) I renamed the field in the table to INVOICENUM and everything works peachy keen...

Thanks for the reply, it got me started in the right direction for sure!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform