To Define the Active Entity

Key in: ACTIVE ENTITY <SQL_INSERT_statement>

AE=<SQL_INSERT_statement>

SQL_INSERT_statement specifies the contents of the row that is to be established as the Active Entity. The statement must specify a table in mscatalog and provide a list of column names and values. For example:

AE=INSERT INTO pumps (cost, vendor) VALUES (25.45, 'Gould')

Note: The ACTIVE ENTITY key-in does not add a row to the database. The Linkage Mode determines whether the Active Entity is copied and added to the database each time a row is attached to an element with the Attach Active Entity tool.

Note: Keying in AE=$ is equivalent to selecting the Show Active Entity tool in the Database toolbox.