Data Source Count

hi

how to get the count of temporary data source. i can iterate and can get the count by

hreadfirst(ds)
while not hout(ds)
count++
hreadnext(ds)
end

but is there a easy way to get that.

ds is Data Source
HExecuteSQLQuery(ds,"Select * from application where organisation_id='1'")

Regards,
Prolay

Hello Prolay,

HNbRec should give the result.

HTH.

What about :
SELECT COUNT(*) ?
Bjoern