TOracleQuery.rowcount??

[aimeel]

How reliable is rowcount? I have a situation where I set a breakpoint on qry.execute and manually run the query in SQLNav to come back with 0 rows. I continue stepping through my code and qry.rowcount = 0 fails (qry.rowcount > 0 passes). I know this record does not exist. Is there a better way to find out if any rows were returned from a query?

 

[KaeOl]

If the query returns no rows, the TOracleQuery.EOF is false after execute.
You may check:

IF Qry.EOF
THEN // no rows
ELSE // rows returned

Oliver