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?

I've looked at FIBPlus and feel that it is one of the fastest (if not the fastest) IB components out there. Congratulations on doing such a fine job. >>

Barry McClure

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.

Navigation