|
Q: How to fill two linked tables with data?
A: Create a project with two data
rules: the first one will fill in the parent (master) table and
the second one will fill in the child (detail) table. At the same
time, the program will automatically offer the method of filling
based on FK (foreign key) values.
A: Run rule wizard and to select
"create data generation rules for the selected tables
automatically" options. The program will create necessary rules
automatically.
Q: Are there any restrictions concerning the number of
fields in a table or a file?
A: Yes, the program supports approximately 420-440 fields
per table. If you need more fields, let us know and we will make a
custom build for you.
Q: How to make the number of digits in the generated
number fixed?
A: The easiest variant is to specify a range. For example,
if you want integers to have 3 digits each, specify the range from
100 to 999.
Q: How to fill fields with values depending on other
values in this or some other table?
A: Fill the column with random values and then use an update
statement, specifying it as a script executed after the rule. During the rule
execution, the program will fill out the table, while the script
will set the values of calculated or dependent columns.
A: Use "by expression" fill method. Please note that this solution is faster
that previous but some database systems does not compatible with
it.
Q: How to enter a date value into a field without
specifying time?
A: Open the Settings page and
specify the time format as an empty string.
Q: How to fill two columns (A and B) from one linked
table coordinated?
A: Fill the first by SQL query like
"select Column1,Column2 from LinkedTable". Next, create group consists of A and B columns.
A: Use "from table" fill method for both columns with
required linked columns (Column1 and Column2 from example above)
and switch ON "use vaues from list sequentally". In this solution
data will be not really random but it is acceptable for most
cases.
|