You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Current »

It is possible to dynamically generate complete programs and execute them using the scriptexec statement. The following example imports the Orders table from the Northwind odbc data source. The generated code, should be in the tiImport language syntax.
Example:
DATASOURCE a1 = odbc 'dsn=northwind'
DECLARE @tableName as string
SET @tableName = 'Orders'
ScriptExec 'import [' + @tableName + '] = a1.[ ' + @tableName + '] '
SAVE

  • No labels