Column Specifications view in the DataWindow painter
Description
Shows a list of the columns in the data source. For each column
you can add, modify, and delete initial values, validation expressions,
and validation messages. To add a column to the DataWindow object,
you can drag and drop the column from this view to the Design view.
For external or stored procedure data sources, you can add and delete
columns using the pop-up menu.
Options
Name, Type, Length, Decimal
TIf the data source is external or stored procedure, you can
modify these values.
Prompt
Check if you want a column to be included in a prompt for
retrieval criteria during data retrieval.
Initial value
Enter an initial value for the column. The value must be valid
for the data type of the column. If an initial value was defined
for the column in the Database painter, the column displays that
value and you can modify it.
Validation Expression
Enter the validation expression you want to use to validate
user-entered data in the Validation Expression column of the table
for each column for which you want to specify a validation rule.
If a validation rule was defined for the column in the Database
painter, the column displays the rule and you can modify it.
When you enter a validation rule, you must include the column
name in the expression. For example: qt_remaining < 100.
Validation Message
Enter the message you want to display with a validation error.
If you do not enter message text, the column displays the standard validation
error message: Item item_name does.
not pass validation test
DB Name
Displays the database name and column name in the database. If the
data source is external or stored procedure, you can modify these
values.
Example
The initial value for the order_date column is 0000-00-00
and to pass the validation rule the due date column must be more
than 60 days after today’s date:
|
Name |
Type |
Initial |
Validation expression |
|---|---|---|---|
|
order_date |
date |
0000-00-00 |
|
|
due_date |
datel |
DaysAfter( Today(), datetime(due_date)>60 |