How to convert VFP cursors into MySQL code keeping funcionality?
Hi Experts!
I'm starting to convert VFP data management code into MySQL.
Since I've used cursors in my VFP code by creating cursors and then using cursors created just before in another cursor creation, I don't know how and even if it could be done in a similar strategy in MySQL SP(s).
(There the cursors are used as a line by line fetching data)
Have you faced this issue. If so, how to workaround it ?
Thanks in advance!
I'm starting to convert VFP data management code into MySQL.
Since I've used cursors in my VFP code by creating cursors and then using cursors created just before in another cursor creation, I don't know how and even if it could be done in a similar strategy in MySQL SP(s).
(There the cursors are used as a line by line fetching data)
Have you faced this issue. If so, how to workaround it ?
Thanks in advance!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, SQL cursors could substitute VFP cursors but you should use them if there is no other option. They are slow and any other solution implemented as SQL-SELECT is much faster obviously.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello
After a quick overview about the article you've pointed I concluded being in the right path, using MySQL data storage and manipulating everything possible. Using PHP just to trigger and receive data manipulation in MySQL.
I'm just starting, I've downloaded a MySQL Debugger (trial version) and I've migrated (translated) a relative complex VFP routine into MySQL. The debugger resembles the VFP environment,so after some adaptations I feel the job could be done quickly!
After that I'm going to adapt some PHP classes for the cliente side.
After a quick overview about the article you've pointed I concluded being in the right path, using MySQL data storage and manipulating everything possible. Using PHP just to trigger and receive data manipulation in MySQL.
I'm just starting, I've downloaded a MySQL Debugger (trial version) and I've migrated (translated) a relative complex VFP routine into MySQL. The debugger resembles the VFP environment,so after some adaptations I feel the job could be done quickly!
After that I'm going to adapt some PHP classes for the cliente side.
ASKER
Could substitute VFP cursors.
Actually VFP manipulates the data heavily and since I'm using PHP the client code must be thin...
The upgrade data from VFP to MySQL itself was solved.