Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter with MySql
Message
From
27/06/2005 16:53:38
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
CursorAdapter with MySql
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Novell 5.x
Database:
MySQL
Miscellaneous
Thread ID:
01026870
Message ID:
01026870
Views:
63
I create an ODBC connection with a MySql Data Base, and use the class CursorAdapter too.
But i have a problem with an field ID(autoinc). When i execute the TableUpdate i have to use the CursorRefresh to get the new ID genereted. But with the CursorRefresh i lost the reference to the new record, it´s seems the comand moves the pointer to the begin of the file. How can i proced in this case, cause i need to get the new ID for the new record. There is another way to get the new ID without using CursorRefresh?

Thanks

Ricardo Possas
Next
Reply
Map
View

Click here to load this message in the networking platform