SQL Question

[TechRangerBrad]

Not sure if this is the correct forum. I am still getting my feet wet around here.

Is there way using SQL to push data changes back up to another DB app from FM?

So in other words, with ODBC I get info from another DB into FM and then make changes, can I push it back up to the other DB using SQL commands?

Thanks

[tgilders]

Absolutely.

You can use the "Execute SQL" script step to create the SQL Statement. You have the full calc engine available to dynamically generate the SQL Statement on the fly. (or in a loop, etc...)