I'm doing a conversion process that can be hook to any external ODBC source.
So I wrote 'Connector' script that let me dynamically define the source fields names and layout name to read the values needed.
I use a script to export the 'unique key' from the external source DB and import them in the local DB, creating all needed records. Making relationship from that unique key.
Then a generic script called 'ReadDataSource' do the job in the DB for the rest of the fields needed:
After that, I do the conversion on the data and then I need to export it back to the external source DB.
The problem is that there is no script command 'Replace Field Contents By Name[...]' like the script command 'Set Field By Name[...]' flavor!
Doing a loop for each records (~100,000) and use the script command 'Set Field By Name[...]' is time consuming!