ACTIVE ENTITY (AE=)

Used to define the Active Entity without specifying an existing row.

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')

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.

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