Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter with MySql
Message
From
01/07/2005 09:45:29
 
 
To
27/06/2005 16:53:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Novell 5.x
Database:
MySQL
Miscellaneous
Thread ID:
01026870
Message ID:
01028125
Views:
17
Hi Ricardo !

You have create an ADO connection to keep the reference of the record!



>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
Atenciosamente,
Welington Lourenço Melo de Paula BH / MG
welingtonl@yahoo.com.br
Previous
Reply
Map
View

Click here to load this message in the networking platform