Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sqlpassthrough connection
Message
 
 
To
19/09/2002 08:36:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00697399
Message ID:
00703057
Views:
41
There still should not be a problem with the connection that queries that data. I think we should be looking at this from the angle of how the records are being added to the database. If you issue from the command window:

? SQLGETPROP(nHandle, 'Transactions')

It should be 1. If it is 2, then you have to handle the COMMIT of the data manually with a SQLCOMMIT() or SQLROLLBACK(). How are you handling the addition of new records? Are you doing this testing using 2 different connections, from 2 machines or 2 instances of VFP?
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform