Uwe Oeder wrote:

> Thank this helped a lot. However is there anyway in which I can know how
> many rows are in the result set before I run through the data. So is there
> anything equivalent to the mysql mysql_num_rows() function in firebird ? It
> is important for me how many rows were returned from a query as this will
> influence what further script must run.

ADOdb does a COUNT(*) based on the query if that is enabled. Personally
I add my own extra query to give me a SELECT COUNT(*) WHERE ... when a
need a count rather than slowing everything down by leaving ADOdb to do
it every time. It also means that I can skip bothering with the full
query if the answer is '0' and just give a message :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services