Blank behaviour
Hi everyone,
I'm building a report for my POS system. In the report, I have a field
link to
totcomple of a TQuery contain the following statement.
select sum(total) as totcomple
from txb
where (CDATE = :cdate)
and (COMPLE = 'Y')
and (VOIDED = 'N')
The problem is, when the query returns blank(i.e.: no record match the
specified
criteria), then field shows blank there. Am I missed something? Or is there
any
way for it to show 0 then the result is blank?
I'm using Delphi 5 with Update pack 1 with RB Pro 6.03.
I'm building a report for my POS system. In the report, I have a field
link to
totcomple of a TQuery contain the following statement.
select sum(total) as totcomple
from txb
where (CDATE = :cdate)
and (COMPLE = 'Y')
and (VOIDED = 'N')
The problem is, when the query returns blank(i.e.: no record match the
specified
criteria), then field shows blank there. Am I missed something? Or is there
any
way for it to show 0 then the result is blank?
I'm using Delphi 5 with Update pack 1 with RB Pro 6.03.
This discussion has been closed.
Comments
Just use the ppDBCalc instead of ppDBText to display the field will do.
"Lau Lei Cheong" ???g???l???s?D:3d7ebce6@dm500....
there