TurboData is not displaying a tables foreign keys
First ensure that the foreign keys are correctly set up on your DBMS. If they are, then the problem is probably due to your database access provider. Use a direct OLE DB provider to access the database if you can. If you need to use ODBC with a DSN then you will probably not be able to read in the foreign keys automatically. In that case use the Edit Database Schema dialog to manually set the foreign keys.
I tried to generate a range of test data, but only the first few Insert SQL statements were created.
This can occur if you have set up a column to read in test data from an other data source, such as an input text file, and the End of Values selection is set to Stop. If the end of the file has been reached before the desired range of Insert SQL statements have been generated, then TurboData will stop processing Insert SQL statements for that table.
Dates are only showing 2 digit years in the Edit Data grid, and in the results from Running a Select SQL statement from the SQL Builder dialog.
This is due to your Windows system settings. From the Settings, Control Panel, double click on Regional Settings. Select the Date tab, and set the date style to use a 4 digit year (yyyy).
I cannot update a row of data in the Edit Data grid, and a blank error dialog is displayed:
If the attempted change to the data is invalid you will not be allowed to update the data on the physical database. If the reason for the error is known then an error message will be displayed in the dialog box shown above. If the reason cannot be determined by the grid, then the error dialog box will be displayed without any text. Press Escape in each cell that you updated to return the data back to it's original value. To see what the error message should be, create and run an Update or Insert SQL statement using the SQL Builder. This will create an error dialog box with a meaningful error message in it, as can be seen by the following example:
You will then be able to take the appropriate steps to rectify the situation which caused the error to occur.
The Edit Data grid has different tables in the drop down list, to the tables in the TurboData database schema.
The Edit Data grid will display the actual tables that it reads from the physical database you have defined in your Target Database Connection. The TurboData database schema can have any table name and structure you like. If you have edited the database schema, or if you have changed your target database connection to be a different database to your source, then the tables may not match up.
I created a new Insert Data scenario, selected a table with drag and drop, then entered the numbers 55 to 66 in the start to end range. I pressed the Generate push button, but the test data generated used the tables default start and end range, not 55 to 66.
You updated the default settings for the table! In the Data Scenario dialog you must select the table on the right hand tree before entering the start and end range numbers.
