Define list from SQL class

Syntax

Define list from SQL class  query, schema, or table-name(parameters)

Deprecated Command

This command has been deprecated and is no longer visible in the Code Assistant in the Code Editor (it will not appear when you type the first few characters), although it is still present in Omnis Studio and will continue to function if used in legacy code. You can show this command by disabling the appropriate Command Filter in the Modify menu in the Code Editor.

Description

This command defines the column names and data types for the current list based on the specified schema, query, or table class.

This results in the creation of a new table instance associated with the list. If the sql-class-name refers to a table class, the command passes the parameters to the $construct method of the table class.

When reversed, the contents and definition of the list are restored to their former values.

Example

Set current list iMyList
Define list from  SQL class sMySchema
# or do it this way 
Do  iMyList.$definefromsqlclass('sMySchema')