Hi Dave --

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