Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pervasive.SQL Version 8
Message
From
17/05/2005 16:35:52
Kurt Reardon
Business Automation Specialists, Inc.
Florida, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Pervasive.SQL Version 8
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01015082
Message ID:
01015082
Views:
62
I am having a problem updating data with the Pervasive ODBC.

I have tried creating a Remote View making sure Send SQL Updates is checked. I changed data and did a TableUpdate(0, .T.). The TableUpdate returns true, but when I reopen the view, the data is not changed.

I also tried using a CursorAdapter. I have the Send Updates and Auto-update checked and the changes do not seem to go back to Pervasive.

Both of the tests worked fine for me with Microsoft SQL Server. Is there something that needs to be handled differently for the Pervasive ODBC?
Reply
Map
View

Click here to load this message in the networking platform