It is actually built and saved in the MS Server2000/MSDE2000 via the procedures for defining "Single Field" and "Multiple Field".
Delete Table
In the list of "Defined Data Tables", select intended table or tables, then click "Delete Table".
Create Table
In the list of "Defined Data Table", selects intended table or tables and click 'Create Table'. It would create new table or tables in the database.
Update Table
If click "Expand downward", you can change the property of "Expand downward".
If click "Expand rightward", you can change the property of "Expand rightward".
Clicking "Update Table", it will update their property in database.
Delete Field
Selects the intended data field names in the "Data Fields" column, then clicks "Delete Field". It would delete all the selected data field names from the list.
Update Field
The field "PK", "Range", "Field Name", "Data Type", "Not Null", "Input Criteria","Hidden","No Clear" are modifiable. After modifying those items, click "Update Field" to confirm the changes. However, all the changes must be made according to the MS SQL Server2000 metadata regulations.
PK-primary Key
If "PK" is selected in the field, then excel server do not allow saving same data into database when fill the report/form.
Not Null
If "Not Null" is selected in the field, then excel server will check if the filed in null or not when fill the report/form.
Hidden
If "Hidden" is selected in the field, then the field will not appear in right data area of "my work bench".
No Clear
If "No Clear" is selected in the field, then then field is not cleaned when fill the report/form repeatedly.
Sort
If "Ascending" or ""Descending " is selected, the data in data table are sorted by the field.
Up, Down can modify the sequence of fields appear in right data area of "my work bench" and "Query" in ESweb.
The stage follows the creating data table is 'Define Data Fetcher'.