How get UpdatingTable?

[sinys]

How I can get UpdatingTable which selected automatically?

Code: Select all

// SmartQuery1.UpdatingTable = '' by default
SmartQuery1.SQL.Text := 'select * from customers';
SmartQuery1.Open;
ShowMessage(SmartQuery1.UpdatingTable);  // return empty value

In DOA the same properties return table name (which selected automatically) for update if user not set value for UpdatingTable. How I can get table name for update from my query in ODAC?

[AlexP]

Hello,

The UpdatingTable property is set by a user for specifying the table, for which it is necessary to generate UPDATE/INSERT/DELETE/REFRESH SQL queries. If you haven't set this property to SQL, queries for these operations will be generated for the first table specified in the query. To retrieve this table name, you can use the TDBAccessUtils.GetTablesInfo method as follows:

SmartQuery1.SQL.Text := 'select * from customers';
SmartQuery1.Open;
ShowMessage(TDBAccessUtils.GetTablesInfo(TCustomDADataSet(SmartQuery1)).Items[0].TableName);

[sinys]

Thank you!

[sinys]

Can I know the name of the table without "SmartQuery1.Open;" ?

[AlexP]

hello,

Instead of opening the table, you can call the Prepare method:

Code: Select all

SmartQuery1.SQL.Text := 'select * from customers';
SmartQuery1.Prepare;
ShowMessage(TDBAccessUtils.GetTablesInfo(TCustomDADataSet(SmartQuery1)).Items[0].TableName);