Use this dialog to configure how database table is localized.
Specifies how to generate the primary ids for the localized rows that Sisulizer adds to table. Possible options are:
|Next available value above this value||Enter the minimum value of the primary id. If you want to use some reserved pool for generated row enter a value that specified the start id of that pool.|
|Use stored procedure to get the value||
Select a stored procedure name that Sisulizer calls when it needs a new id. This option is available only if the database support stored procedure and there are at least one stored procedure defined. The stored procedure must not take any parameters and it must return one row where the first field contains the row id.
For example the following stored procedure returns the next available row id.
CREATE PROCEDURE GetNewId RETURNS (rowId INTEGER) AS BEGIN SELECT MAX(RowId) + 1 FROM Country INTO :rowId; END;
|Use following SQL statement to get the value||
Write SQL statement that Sisulizer calls when it needs a new id. SQL statement must return one row where the first field contains the row id.
For example he following SQL returns the next available row id:
SELECT MAX(RowId) + 1 FROM Country
If the primary id field is an auto increment field this group is disabled because database will assing a new id for each row.
Specifies the table specific settings. Check Use table specific settings to use table specific setting. If unchecked source specific settings are used.
Specifies how incomplete row should be handled during the build process. Possible options are:
|Use original string||Use the original value in the field.|
|Use empty string||Write the empty string to the field.|
|Skip row||Skip the row and does not write anything.|
This option is not enabled if database cloning used.