retrieve a record count from Oracle DB

When recordcount is -1 you must be using ADO.
you should use count(*) query to count the records.
if count=0 then
do something
else if
do some thing
end if

thanks
karun

thanks to those who replied.
much appreciated.

i am using ado.

come to think of it, i think i was using a forward only cursor. that would explain alot.

shouldnt you be able to return the number of records affect using some form of the following statement as well

adoconnection.execute strSQL,numofrecsaffected

if so, the cursor shouldn't be forward only???

i am fairly new with ado and extremely new to oracle, just in case anyone was wondering.

Thanks!!!

i never tried using .Execute with
recordsaffected, but reading help,
i think this should work too. if
you try, let me know how it was.

good luck