I have delphi xe7 and using paradox tables with BDE.
Actually, I have more then one database and I'am trying to use one query and one dbgrid for showing the result
1st database in C:\GEST_AP\Base de données\1\beneficiaire
2nd database in C:\GEST_AP\Base de données\2\beneficiaire
my sql code is :
dm.Beneficiaire.sql.clear;
dm.Beneficiaire.SQL.Add('select *');
dm.Beneficiaire.SQL.Add('from "C:\GEST_AP\Base de données\1\beneficiaire"');
dm.Beneficiaire.SQL.Add('FULL JOIN "C:\GEST_AP\Base de données\2\beneficiaire"');
dm.Beneficiaire.SQL.Add('ON "C:\GEST_AP\Base de données\1\beneficiaire".nom="C:\GEST_AP\Base de données\2\beneficiaire".nom');
dm.Beneficiaire.SQL.Add('where "C:\GEST_AP\Base de données\1\beneficiaire".nom like "%'+edit1.Text+'%"');
dm.Beneficiaire.Active:=true;
When I write something on edit1.text it show me just the result for the first database. :(