Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExec - update/rollback
Message
 
 
To
17/03/2010 07:00:46
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01454933
Message ID:
01455038
Views:
40
>I have looked at that, however I was ideally after a basic example that had only the necessary =cursorgetprop()/=cursorsetprop() commands, i.e.
>
>lnConnectionID = SQLConnect('myConnection', 'myDatabase', 'myPassword')
>lnReturnCode = SQLExec(lnConnectionID, 'exec GetMyData', 'myData')
>
>=cursosetprop() (Perform the neccesary changes to the local data to make it updatable, assign updatable fields etc)
>replace myData.myField with 'Complete'
>=perform remote update on SQL Server

We use a similar program to make cursor updatable. I think most of the properties indicated in that FAQ should be set.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform