IQueryStorage.TableName

Syntax

TableName: String;

Description

The TableName property determines a physical name of the table used to save data.

Comments

The property is relevant, if the Enabled property is set to True. The table with specified physical name should be created on the server on which the database specified in the IQuery.Database property is set up. If the Table property is set, the property returns value of the ITable.NativeName property for corresponding table.

Example

Executing the example requires that the repository contains the Query object with the Query_1 identifier. The server where the query is stored, should contain a table with the TestTable physical name.

Sub UserProc;
Var
    MB: IMetabase;
    Query: IQuery;
    Storage: IQueryStorage;
Begin
    MB := MetabaseClass.Active;
    Query := MB.ItemById("Query_1").Edit As IQuery;
    Storage := Query.Storage;
    Storage.Enabled := True;
    Storage.TableName := "TestTable";
    (Query As IMetabaseObject).Save;
End Sub UserProc;

After executing the example, the settings of specified query are changed. Saving data is enabled for the query. Data is saved in the table with the specified physical name.