Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating informaiton in SQL Server table not working
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Updating informaiton in SQL Server table not working
Miscellaneous
Thread ID:
00966723
Message ID:
00966723
Views:
49
I am trying to learn how to update a SQL Table using remote views - but it does not work.

I implemented the following test code:
SET MULTILOCKS ON  && Must be on for table buffering
OPEN DATABASE certification_information
USE driver_info IN 0 && Remote view pointing to SQL table
SELECT driver_info
= CURSORSETPROP('Buffering', 5, 'driver_info' )  && Enable table buffering

BROWSE
REPLACE lastname WITH [test]


lv_result = TABLEUPDATE(.T.)  && Commits changes
? lv_result
Which runs fine (TABLEUPDATE returns a .T.), except that it does not update the SQL table.

Thanks in advance for your help!
Michael Meinberg
Tamtech, Inc

"The amount of things that I know nothing about is alarmingly increasing."
Next
Reply
Map
View

Click here to load this message in the networking platform