SQL Programming
Changing Field Names in InsertDataFromCursor
Gravatar is a globally recognized avatar based on your email address. Changing Field Names in InsertDataFromCursor
  Bob
  All
  Mar 10, 2020 @ 09:42am

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?

Gravatar is a globally recognized avatar based on your email address. re: Changing Field Names in InsertDataFromCursor
  Rick Strahl
  Bob
  Mar 10, 2020 @ 11:49am

Is performance really a concern for a one time update routine?

+++ Rick ---

Gravatar is a globally recognized avatar based on your email address. re: Changing Field Names in InsertDataFromCursor
  Bob
  Rick Strahl
  Mar 10, 2020 @ 12:27pm

Not a huge concern. Just thought I would ask since we have to do a conversion for 220 customers.

© 1996-2020