Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP loses data after commit
Message
From
24/03/2004 06:34:40
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
 
To
24/03/2004 03:36:23
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00889142
Message ID:
00889181
Views:
21
Hi,
The file is corrupted, i.e. the file size in the header does not equal the actual file size, this is a documented bug. It is usually a couple of extra characters on the end of the file, just append blank then pack and reindex.
It causes the transaction tracking to fail. See link http://support.microsoft.com/default.aspx?scid=kb;en-us;293638&Product=vfp6

Regards N Mc Donald

>Hi,
> I am working with VFP6 SP5 and am facing very peculiar problem. I have an import module that imports data from VFP free tables into my database tables most of the times that the data comes across fine but sometimes VFP loses data. I am importing within a transaction using APPEND FROM stmts.
>The problem is random in nature and cannot be easily reproduced and comes to fore only after some report or other does not bring up the expected data. On inspecting I have found that some fields do not contain the values as ones in the incoming tables.
>Has anyone encountered problems of this nature?
>
>All/any help is greatly appreciated...
>Thanks in advance,
>Kapil.
Regards N Mc Donald
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform