Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updateable cursor
Message
From
06/05/2001 16:19:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Updateable cursor
Miscellaneous
Thread ID:
00504030
Message ID:
00504030
Views:
60
Can someone help me with this passthrough problem. I am using SQL passthrough to get a cursor. I want to make the cusor updateable so that the updates get updated on SQL server. Below are the steps I use:

1.) lnHandle = SQLCONN(DSN,'USERID','PASSWORD') &&Get my connection.
2.) lnExe = SQLEXEC(lnHandle,'Select * from table','Mytable') &&Get the data.
3.) lnProp1 = CURSORSETPROP('tables','mycursor') &&Name of remote table, I put the name of my cursor as the name of the remote table.

4.) lnProp2 = CURSORSETPROP('SendUpdates',.T.)

Step 5 is when I get an error!!!
5.) lnProp3 = CURSORSETPROP('buffering',3) &&I get an error telling me that 'No update tables are specified, use the tables property of the cursor'

Why am I getting that error?

I also try to use the tableUpdate method:
lnUpdate = tableupdate(1,.t.,'testp') &&This returns .F.

Help!!!!
What is the problem.
Next
Reply
Map
View

Click here to load this message in the networking platform