Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for RAD Studio XE (Delphi) » Using DBISAM » Live Queries and Canned Queries |
Type | Description |
Live | The result set is editable and all changes are reflected in the source table. |
Canned | The result set is editable but changes are not reflected in the source table(s). |
begin with MyQuery do begin SQL.Clear; SQL.Add('SELECT * FROM customer INNER JOIN'); SQL.Add('INNER JOIN orders ON customer.ID=orders.CustID'); SQL.Add('WHERE customer.ID=1000'); Open; { In this case the result set will be canned due to the join condition } if ResultIsLive then ShowMessage('The result set is live') else ShowMessage('The result set is canned'); end; end;
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |