Error report using parameters
Hi everybody...
I??m using Fast Reports 4.7.3, and I have a problem.
The script bellow is used as master details and I??ve programmed that using parameters (bold type), typed by the user.
select distinct codcliforn, razao
from movimentacoes
left join cliforn
on movimentacoes.codcliforn = cliforn.codigo
where dataemissao between :datainicial and :datafinal
and codcliforn = :codcliforn
However, I??m getting the error bellow
Error
The following error(s) have occured:
ADOQuery1: ADOQuery1: Error in expression '': Expression expected
ADOQuery1: Error in expression '': Expression expected
OK
In ADOQueri1 parameters properties I??ve declared all the variables... In the query analizer, it returns the values, but when I run into the project, I got the error above. Can anyone help me please? Thx
I??m using Fast Reports 4.7.3, and I have a problem.
The script bellow is used as master details and I??ve programmed that using parameters (bold type), typed by the user.
select distinct codcliforn, razao
from movimentacoes
left join cliforn
on movimentacoes.codcliforn = cliforn.codigo
where dataemissao between :datainicial and :datafinal
and codcliforn = :codcliforn
However, I??m getting the error bellow
Error
The following error(s) have occured:
ADOQuery1: ADOQuery1: Error in expression '': Expression expected
ADOQuery1: Error in expression '': Expression expected
OK
In ADOQueri1 parameters properties I??ve declared all the variables... In the query analizer, it returns the values, but when I run into the project, I got the error above. Can anyone help me please? Thx