SQL Programming
Changing Field Names in InsertDataFromCursor
I am using the function InsertDataFromCursor in wwSql to convert my FoxPro tables to SQL. I am trying to take advantage of fact that SQL data field names can be longer than 10 characters to clean up some horrible data field names in an application that is mega years old.
Since VFP table and cursor names are limited to 10 characters, I had to write a new program called SQL_Translate that in inserted into the wwsql procedure SqlBuildInsertStatementFromObject to pass in the vfp field name and pass back the sql field name in the build statement.
It works but it adds a bit of overhead to the process.
Can anyone recommend a better to do this?
Is performance really a concern for a one time update routine?
+++ Rick ---