Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No update tables error
Message
 
 
To
02/03/2004 15:12:02
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00882449
Message ID:
00882486
Views:
16
That is an unnecessary step. Cursors created using SQLEXEC are by default read/write.

>I am pulling records from a SQL Server database using ODBC with something like this:
>
>lccmd = [SELECT flda,fldb,flc FROM myTable]
>=sqlexec(lnhandle,lccmd,"tempcurs")
>
>I then want to select the records from that cursor into a readwrite cursor so I can perform and record some calculations. I do this
>
>SELECT * from tempcurs INTO CURSOR myNewCurs READWRITE
>
>I receive the error message: "No Update Table are Specified. Use the Tables property of the Cursor.
>
>I have not seen this before. What am I missing?
>
>Paul Montgomery
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform