|
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 that don't support this method.
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
|