I have a question a bit like this open already, but since I need the answer now I will try to ask it again.
I try this example: http://community.borland.com/article/0,1410,25204,00.html
It shows how to move data betweem two databases, using two TDatabases with databasenames: aaa,bbb and one Query with this SQL statement
INSERT INTO ":aaa:Country" SELECT * FROM ":bbb:Country"
I get this error: No such table or correlation name, when I try to execute it.
If I use the aliases instead of the databasenames it works fine, but I then have to enter the password and username explicitly, how do I remove this login-dialog.
I uses Interbase, I know that interbase doesn't support heterogeneous JOIN and that BDE performs the function instead.