![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for Delphi 5 » 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 Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |