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

Counter:	2333
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...

FIBPlus is a great product. >>

Alessandro Batisti

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

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