Is it possible to use a prefixed database in TFIBQuery like: DELETE FROM DB1.TABLE1 WHERE DB1.TABLE1.FIELD1 = DB2.TABLE1.FIELD1

Home :: FIBPlus :: Articles :: Frequently Asked Questions (FAQ)

Counter:	1379
Published:	2007-01-29 18:47:45

Question: Is it possible to use a prefixed database in TFIBQuery like:
DELETE FROM DB1.TABLE1
WHERE DB1.TABLE1.FIELD1 = DB2.TABLE1.FIELD1

Answer: No, it is not possible, because InterBase/Firebird do not support such SQL commands.

Prices in Euro:

235 (1 copy)
1250 (unlimited)

Volume discounts are available...

Download
Purchase
Support
Screenshots
Articles
Features
Testimonials
Sales Geography
Who uses FIBPlus?

Well, the ballots are in and the votes for the 2003 Delphi Informant Readers Choice Awards have been tallied - Congratulations Devrace, you are the runner-up in Database Connectivity category! >>

Debbie Holmgren, VP of Sales, Delphi Informant Magazine

FOR CUSTOMERS
Download full versions and updates in our Customer's Center

Is it possible to use a prefixed database in TFIBQuery like: DELETE FROM DB1.TABLE1 WHERE DB1.TABLE1.FIELD1 = DB2.TABLE1.FIELD1

Fast, flexible and high-performance component library for Delphi, C++ Builder and Kylix intended for work with InterBase and Firebird using Direct InterBase API.