>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.

I think it's looking for the remote data object. ie.
cursorsetprop("Tables","dbo.Table")