Hi all. I have a portion of a program that I need to change from connecting to a MySQL db to connecting to a VFP database.
The table names and the data they contain are identical. Below is a sample select that I am currently using with MySQL.
Is there a way I can change just the connection in order to avoid having to rewrite all the select, update and add queries throughout the program?
lcTableName = "supplier"
lcCursor = "MySQLResult"
lcQuery="SELECT supplier_id FROM " + lcTableName + " WHERE supplier_id < ?lnSup_ID ORDER BY supplier_id DESC LIMIT 1"
IF lnResult < 1
DO SQLQueryError IN error_messages WITH lcQuery