Hi, William!
This is also an answer to your "CURSORSETPROP tables problem." thread.
I developed this for SQL Pass-Through (SPT) cursors. You can find tips of how to do this in my and FoxDev posts at the
http://www.tek-tips.com, VFP forum.
However, this is easy to develop by your own.
Make a remote view. Open it and look to appropriate cursor properties. You will see an exact format of the information in these properties. Use this format to populate properties of your SPT cursor. There are 5 of such properties that you should set in SPT cursor. Read also articles about SPT in the VFP developers guide, these properties are described there for SPT.
HTH.
>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.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.