1 2 3 4 5 6 7 8 9 10 11
| const SQLOracle = 'SELECT t.Employer_Num, t.Date, t.Libelle, b.Nom, SubStr(t.Lib, 7, 15) Lib_Nom, SubStr(t.Lib, 1, 6) Lib_Nom1, Sum(t.Credit) As Credit,FROM Table1 t JOIN Table2 b '+
' ON t.Centre=b.Centre AND t.Employer_Num = b.Employer_Num '+
' WHERE t.Centre = %d And t.Journee = %s And t.Canaux = %s '+
' Group By t.Employer_Num, t.lib, b.Nom, t.Date Order by SubStr(t.Libe, 1, 7), t.Employer_Num';
var SQLParam : String;
unedate : date;
begin
SQLParam:=Format(SQLOracle,[1001,FormatDateTime('yyyymmdd',unedate),quotedstr('9')]);
ADOQuery1.SQL.Text:='SELECT * FROM OpenQuery(LinkedOracle9i, '+Quotedstr(SQLParam)+'); |
Partager