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.