General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only