Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data Corruption Using Cursors from SQL in Fox
Message
 
To
12/04/2001 11:16:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00494869
Message ID:
00495309
Views:
15
We have the same problem with a particular table too. In our reproducable error situation, the problem occurs with a transactional delete in a row-buffered remote view with 10 records.

begin transaction
delete
sqlcommit ...
end transaction

The chr(0)-error occurs with the command "end transaction".

Microsoft tested the code too, they said with VFP7 Beta2 the error doesn't occurs.

We found out, that the error doesn't occur, when the remote view contains only one record. So we made a SPT-cursor for navigation with 1:1 relation to a master for data entry.

Bye,
Andreas
Previous
Reply
Map
View

Click here to load this message in the networking platform