Table (for Create) DataWindow object property
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.
Caution
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:
-
Export your DataWindow object to a DOS file.
-
Copy only the table section into your script.
-
Modify the table section to meet your needs.
-
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 (~~'). -
Call Modify. Modifying the table
section of your DataWindow causes the DataWindow to be reset. -
(Optionally) Call Modify to add
the column to the DataWindow display.