![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 Manual for Delphi 7 » Using ElevateDB » Querying Database Objects |
// This example uses a query component that // has already been created and opened // called MyQuery with MyQuery do begin DatabaseName:='SalesDB'; SQL:='SELECT * FROM Information.Tables '+ 'WHERE Name='+Engine.QuotedSQLStr('Customer'); Open; if (RecordCount=1) then ShowMessage('The Customer table exists') else ShowMessage('The Customer table does not exist'); end;
// This example uses a database component that // has already been created and opened // called MyDatabase with MyDatabase do begin if (Execute('SELECT * FROM Information.Tables '+ 'WHERE Name='+Engine.QuotedSQLStr('Customer'))=1) then ShowMessage('The Customer table exists') else ShowMessage('The Customer table does not exist'); 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 ? ![]() |