Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating informaiton in SQL Server table not working
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Updating informaiton in SQL Server table not working
Divers
Thread ID:
00966723
Message ID:
00966723
Vues:
48
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."
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform