|
|
|
|
|
TestBase 3.0 1 2 3 4 5 6 7 8 9 You'll have the same General and Output tabs as explained above, but will now have a relationships tab. This is where you define the relationship between tables. Since it is a child table, the general tab looks slightly different. Instead of specifying the number of rows, you specify the minimum and maximum number of rows. Mine were set for 0 to 10. This means that for each parent row inserted, between 0 and 10 rows will be generated for the child table.
Numeric columns can be filled a variety of ways. You can use a sequential, random, or constant value. You have the ability to autonumber and specify if the values should be unique. If it is a decimal datatype, you can specify the number of decimal places to be used. If you have a particular range of values, you can use either a data table or a value from your database. This is what makes TestBase so flexible and powerful. A data table is a compiled binary file consisting of data to be used. TestBase ships with a set of data tables, but you can create your own. If you already have data in a database such as a list of products, salespeople, etc., this data can be used to generate test data.
|
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
