Table (for Create)

Description

The section of the DataWindow syntax that specifies information about the DataWindow’s database table, including the name of the update table.

Use Table in DataWindow syntax for the Create method.

Syntax

Does not apply.

Usage

Use this property to redefine a DataWindow result set. You can add a column, change the datatype of a column, or make other changes to the table section of your DataWindow involving properties that are not accessible through Modify calls or dot notation.

NoteCaution When you use this property to redefine the result set, you must redefine the table section in its entirety.

You can call the GetItem and SetItem methods to access columns added using this property, but the columns do not display in the DataWindow unless you call Modify("create column(...)") to add them.

To redefine your table section:

  1. Export your DataWindow object to a DOS file.

  2. Copy only the table section into your script.

  3. Modify the table section to meet your needs.

  4. Put the new table definition into a string variable. Change existing double quotation marks (") in the string to single quotation marks (') and change the tilde quotation marks to tilde tilde single quotation marks (~~').

  5. Call Modify. Modifying the table section of your DataWindow causes the DataWindow to be reset.

  6. (Optionally) Call Modify to add the column to the DataWindow display.