1 2 3 4 5 6 7 8 9
| form1.ADOQuery1.SQL.Clear ;
form1.ADOQuery1.SQL.Add('SELECT T1.AGENCE, T1.NUM, T1.NOM, T1.CDPROF,');
form1.ADOQuery1.SQL.Add(' T1.GRAGCE, T1.GRNUM,T1.PERSONNE, T1.TITRE, T1.DATNAIAA, T1.DATNAIMM, T1.DATNAIJJ,T1.ADR1,');
form1.ADOQuery1.SQL.Add(' T1.BPLIB, T1.BP, T1.VILLE, T1.ADR3, T1.PHONE, T1.TELEX, T1.RESPON, T1.ZONEGE, ');
form1.ADOQuery1.SQL.Add(' T1.BQNOM1, T1.BQNOM2, T1.BQNOM3, T1.BQNOM4, T1.RIBBQU, T1.RIBGCH, T1.RIBCPT, T1.RIBCLE, ');
form1.ADOQuery1.SQL.Add(' T1.NOTES, T1.CODEPAY, T1.CDTCA, T1.TXTCA, T1.CDTE, T1.TXTE, T1.CDCP, T1.CDFRA, ');
form1.ADOQuery1.SQL.Add(' T1.FLAGINC, T1.FLAGPGB, T1.CDPRODUC, T1.CDINDIC, T1.FLAGBNS, T1.SITU, T1.CREDIT, T1.DATRELAA, T1.DATRELMM, T1.DATRELJJ');
form1.ADOQuery1.SQL.Add('FROM DLALIB."EPR.CLNT" T1');
form1.ADOQuery1.Open ; |
Partager