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

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.

Preview text:

Prices in Euro:

235 (1 copy)
1250 (unlimited)

Volume discounts are available...

Navigation

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

In the 30 years in the IT industry from development to IT Manager, I have
rarely used third party components but I would not be without your product. >>

John Hart ,Tradewinds Software Pty Ltd

FOR CUSTOMERS
Download full versions and updates in your Personal Area

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.

Navigation