Hi, Eric!
You're incorrect. Please, read following article in the MSDN:
Programmers guide, Chapter 21: Implementing a Client/Server Application, Working with Remote Data Using SQL Pass-Through, Updating Remote Data with SQL Pass-Through.
See also my answer to this question.
>? SQLEXEC(1, [SELECT Vdr_No, vdr_add3 FROM VNDR WHERE Vdr_No = 9141], [MyCur])
>
>This opens a local cursor, not an updateable remote view.
>
>? CURSORSETPROP('SendUpdates',.T. ,'mycur')
>
>Contains true (.T.) if a SQL update query is sent to update tables when an update is made using the view <-----
>
>? CURSORSETPROP('Tables', 'KPOPS.VNDR')
>? CURSORSETPROP('UpdateNameList','vdr_add3', 'MyCur')
>? CURSORSETPROP('KeyFieldList','vdr_no', 'MyCur')
>? CURSORSETPROP('UpdatableFieldList', 'vdr_add3, vdr_add3', 'MyCur')
>
>The rest of these, I believe, only apply to a view.
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.