>I enterd the cursor properties as you stated and and when I use TABLEUPDATE(1,.t.,"tablename") I still get a return of .F. and aerror() shows once again the error to be 'No update tables are specified. Use the Tables property of the cursor.'
> I am using a remote view, and I set the cursor table property as
>CURSORSETPROP("Tables","owner.table"). This cursor is called using sqlexec()
>You said to use the schema name within the CURSORSETPROP("tables","schema.tablename.field). What would be the schema name?
The schema name is the user ID the tables are created under. Your problem with creating a cursor from a remote source is specifying the connection to use. AFAIK, you can not specify this. You either have to create a remote view or use SQLExec() to send your updates back to the server. This is really what VFP does with remote views behind the scenes. I suggest looking at GetNextModified() and GetFldState() functions in VFP help as well. You would use those to build your SQL string, then use SQLExec() to pass that update, insert or delete string.
Mark McCasland
Midlothian, TX USA