Generating Primary Keys and Defaults

Using SQL Functions

Enter value (New York for example) into SQL function field and following SQL would be executed while inserting the data.

insert into Customers (CustomerID,,,,City)
values (CustomerValue,,,"New-York")

Using Defaults

Enter value (New York for example) into default field and this value will be used for inserts if source field is null or empty.

Note:

To insert empty string enter ’’ into default field.