Product Home
DTM Data Generator Online Documentation Prev Page Prev Page
General
Product Profile
Product Versions
Quick Start
Rule Wizard
System requirements
Connect to Database
Project Properties
Program Settings
General
Interface
Rule and project
Execution
Date and Time Formats
Execution
Random BLOB Loader
Project migration
Database Model Viewer
Fill Table Rule
Table Fill Modes
Table Fill Options
Tables options
Columns options
Row count tab
Scripts
Rule Output
Preview
Fill Methods
Method Options
Random values
Values list
From table
List from file
From Values Library
Incremental
By mask
By SQL statement
By formula
Custom generator
Named Generators
Field groups
Advanced Rules
Clear Rule
Tables Creation Options
Objects Creation
File Rule
Advanced Features
Tables Selection
Table Information
Value Library
Command Line
Performance Tips
Performance mode
Format Strings
Select column
Data export
How to...
Additional Info
Product Ordering
Database Utilities
Licence agreement
Demo version
Install
Uninstall
Upgrade
Support
Glossary

By formula fill method

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.

By formula/expression fill method setup window

Examples: sysdate()
Column1+3