I'm transferring many tables (967) from single BDE .DBF files (old driver DbIV) to Firebird 2.5.
I utilize Delphi 7 as environment and ZEOS components to Firebird connections: the work is enough easy. A large number of old queries contain UNIONS and JOINS of tables (-> single files .DBF), but now the old .DBF tables are transferred in different Firebird Databases. For example, with the two tables Municipalities.Dbf and ZipCodes.Dbf, I can write with BDE a query "SELECT * FROM MUNICIPALITIES.DBF a INNER JOIN ZIPCODES.DBF b ON ()... WHERE..."; now the first table is in WorkCom.fdb database, and the second table is in the TabCom.fbd database: how to join to day the tho tables? My program utilizes this queries and I would want to find solutions that give a fast result as BDE. I know that is not possible for Firebird to join tables that "resides" in different databases (.fdb), but I must find a solution as elegant as possible to join the same FB tables previously joined with .DBF files. Do you have any suggestion as to how to solve this problem? Thanks in advance. --- Questa e-mail è stata controllata per individuare virus con Avast antivirus. https://www.avast.com/antivirus ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/