Using the result of a query. 1

[terrytype]

I use Delphi6 Professional.

I have a query [qryDLTBError] in which the SQL code is
SELECT SUM (Balance)
FROM "c:\h\StdAcc\DL"

which produces 'SUM OF Balance'

I need [something like] "IF qryDLTBErrorSUM OF BALANCE <> 0 then
begin
do something;
end;

This obviously does not work.
What would be the appropriate code?


Old Man Delphi

 

[imex]

Try something like that:

SQL code:

SELECT SUM (Balance) as sumofbalance
FROM "c:\h\StdAcc\DL"

Delphi code:

if qryDLTBError.FieldByName('sumofbalance').Value <> 0 then
begin
  // do something;
end;

I hope this helps.


Imoveis comerciais em Guarulhos

 

[terrytype]

Thanks imex
You cannot possibly know how you have made the day of this old man!
How important that advice [which works [perfectly!] was to me.
Have a HUGE day!!

Old Man Delphi