Consulta SQL
05/04/2006
0
DM.CdsPedidos.CommandText := ´SELECT a.*, b.nomcli FROM ftsolicitacao1 a, ftclientes b WHERE a.codcli = b.codcli and datsoc BETWEEN ´´´+EDatini.DateText+´´´ AND ´´´+EDatfin.DateText+´´´´;
Felipeiw
Posts
05/04/2006
Camilo
´SELECT ´+
´ a.*, b.nomcli ´+
FROM ftsolicitacao1 a
left outer join ftclientes b on (a.codcli = b.codcli)
where datsoc BETWEEN ´´´+EDatini.DateText+´´´ AND ´´´+EDatfin.DateText+´´´´;
05/04/2006
Emerson Nascimento
with DM.CdsPedidos do begin CommandText := ´SELECT a.*, b.nomcli ´+ ´FROM ftsolicitacao1 a ´+ ´inner join ftclientes b on (b.codcli = a.codcli) ´+ ´WHERE datsoc BETWEEN :dataini AND :datafim ´; Params.ParamByName(´dataini´).AsDateTime := data_inicial; Params.ParamByName(´dataini´).AsDateTime := data_final; Open; end;
06/04/2006
Felipeiw
Abs
Clique aqui para fazer login e interagir na Comunidade :)