|
This fill method has a number of usage limitations. First, you
shouldn't use recursion, i.e. you shouldn't use columns generated
with this fill method in the formula. Second, there are some DBMS
and data formats that don't support this method at all. It happens
when expressions in the INSERT-values list aren't allowed. Also,
instead of showing final values, the preview window shows
expressions that will be sent to the database as values. You can
use built-in functions of the target database in a formula if the
INSERT statement syntax allows such usage.
Also, this fill method does not supported by Standard version of the Data Generator.
Please note that the program will use expression in INSERT or
update SQL statement as is. That means your formula must be correct
expression for target database system.
Examples: sysdate()
Column1+3
Note: we recommend to use this method only if you need to
apply built-in function of your database system. Otherwise,
'by pattern' fill method is more
flexible.
|