Hello,
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