|
Introduction |
|
Using SQL File Import |
|
|
Scripting
The
scripting feature (Pascal-like) adds lots of new possibilities to
customize your import process. Some conventions about the scripting
language are as follows:
|
·
|
it is
not case sensitive
|
|
·
|
every
code block is surrounded by a begin..end block
|
|
·
|
each
statement must end with a semi-colon e.g. a := 2;
|
|
·
|
assignment
operators use the following form (:=) e.g. a := 2;
|
|
·
|
string
are enclosed in single quotes e.g. aVariable := 'A String';
|
For each column that you import data into, you can use scripts to
dynamically change the value where required. This is done in the
OnBeforeUpload
function,
which occurs before the data is imported into the table. There is
also an OnAfterUpload
function,
which is called after the entire row has been imported into the
table.
To get started on scripting, see the sample tasks to get an idea of
how scripts can be used to dynamically generate values and change
the source data before it is imported into the database.
If you require help on scripting, you can post your question on our
support forum at
http://www.yohz.com/support/index.php,
or contact us directly at
support@yohz.com.
|