Hi Dave --
Whoops. Almost forgot: A trick I use is that if all else fails, I create a remote view. If it works, I then run GENDBC versus the database container and then look at the resulting source code. That will show you how your properties should be set.
>
>What is the source of the remote table? If it's SQL Server, then you may wish to put the database name in front of the table name as in:
>
>=CURSORSETPROP("Tables","dbo.history","ahistory")
>
>
>>I am attempting to update a remote table using sqlpassthru.
>>
>>Here is the error I get:
>>"No update tables are specified. Use the Tables property of the cursor."
>>
>>Here is my code that I run from the command window:
>>
>>x = sqlcon("smccmpinv")
>>y = sqlexec(x,"select * from history","ahistory")
>>=CursorSetProp("Tables","history","ahistory")
>>=CursorSetProp("KeyFieldList","tic_id","ahistory")
>>=CursorSetProp("UpdatableFieldList","cred_yes","ahistory")
>>=CursorSetProp("SendUpdates",.T.,"ahistory")
>>replace cred_yes with .T.
>>=Tableupdate()
>>
>>All of the cursorsetprops succeed and the connection and exec also work.
>>The tableupdate() fails. If I attempt to move the record pointer, I get the above error. There is no table or field rule set on cred_yes.
>>
>>Any help is greatly appreciated.
>>Thanks
>>Dave Mihalik
>>
dmihalik@stansleygroup.com
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05