How can I use one query with more then one table and one dbgrid

639 views Asked by At

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. :(

0

There are 0 answers