select works in firebird, but the -104 error in delphi
IBQuery2.SQL.Add('select l.jb_cdempresa, l.jb_cdfilial, p.dtvencimento, l.jb_cdcontacredito, p.vlrpago,');
IBQuery2.SQL.Add('l.jb_cdcontacredito, p.vlrpago, f.cnpj_cpf, f.insc_rg,l.cnpj, l.insc,');
IBQuery2.SQL.Add('from ctaspagar p, lojas l, fornecedores f');
IBQuery2.SQL.Add('where p.cdloja = l.cdloja');
IBQuery2.SQL.Add(' and f.cdfornecedor = p.cdfornecedor');
IBQuery2.SQL.Add(' and p.cdloja = '+(EdLoja.Text)+'');
IBQuery2.SQL.Add('and p.dtlancamento between :Data_Inicial and :Data_Final');
IBQuery2.ParamByName('Data_Inicial').Value:= strtoDate(EdDataIni.Text);
IBQuery2.ParamByName('Data_Final').Value:= strtoDate(EdDataIni.Text);