Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for RAD Studio 10.3 (C++ Win64) » 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). |
{ MyQuery->SQL->Clear(); MyQuery->SQL->Add("SELECT * FROM customer INNER JOIN"); MyQuery->SQL->Add("INNER JOIN orders ON customer.ID=orders.CustID"); MyQuery->SQL->Add("WHERE customer.ID=1000"); MyQuery->Open(); // In this case the result set will be canned due // to the join condition if (ResultIsLive) { ShowMessage("The result set is live"); } else { ShowMessage("The result set is canned"); } }
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 |