property Permanent: Boolean ;
Description
Set Permanent property to true before opening query if you wish the query result to be stored as a table in SQL database. Specify table name as QueryName property. After query is closed, its result can be reopened as using TMedTable component.
By default Permanent is false. Every Permanent query automatically becomes Scrollable.
Example:
qry: TMedQuery;
tab: TMedTable;
begin
// initialization code here
// . . .
qry.SQL.Add('select * from TEST where FN = 20'); // set SQL
qry.Permanent := true; // make it permanent query
qry.QueryName := 'myquery'; // store result as myquery table
qry.Active := true; // open (execute) query
// use query results
qry.Active := false; // close query
// . . .
tab.TableName := 'myquery'; // open myquery as table
tab.Active := true;
// continue with query result
tab.Active := false;
// clean up
end;