Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CURSORSETPROP tables problem.
Message
 
 
To
06/05/2001 23:10:13
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00504046
Message ID:
00504216
Views:
20
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform