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.
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.