Auto Create Recordsets Settings window
Automatically create recordset definitions for selected tables.
When checked, Auto Create Recordsets will run at the beginning of the code generation process.
Create PriKey recordsets checkbox
The checkbox is locked and cannot be unchecked. PriKey recordsets retrieve a single row based on the primary key(s). The SQL statement is:
SELECT column1 [,column2] FROM tablename WHERE prikey1 = @par1 [AND prikey2 = @par2 ...]
The name of the parameters is the column name. For example:
SELECT CountryCodeID, Name FROM CountryCodes WHERE CountryCodeID = @CountryCodeID
The PriKey recordset for a table will not be generated if the table has no primary key(s).
Create GetAll recordsets checkbox
When checked, SELECT * recordsets will be created.
The SQL statement is:
SELECT * FROM tablename
The actual number of rows loaded by the VenturaSQL runtime is limited by the Recordset.MaxRows property. The default limit is set to 500 rows.
Folder name textbox
The name of the folder that will contain the generated recordsets. The folder will be created in the root of the C# project. Clicking the [Default] button resets the folder name to "VenturaAutoCreate".
The excluded tables list
A list of all the tables in the database. The selected tables will be excluded from recordset creation.
Save the settings.
Exclude All button
Select all tables.
Exclude None button
Deselect all tables.
Advanced Provider Settings button
Opens the Advanced Provider Settings window.
Close the window.