Firebird Driver Finally!!

[eluser]Tri.Phi[/eluser]
Hi Carlos,

You're right, unfortunatelly the record pointer advances and a new and undesirable fetch will become necessary.

At the application model, I'm doing some simulations to get records count with:

Code:

num = count($query->row_array());

It seems to work right for while.

About num_rows(), I'm trying to get the original "SQL SELECT statement" from the query, and then do a new query over that for count, something like this:

"SELECT 1 FROM (SELECT statement)" and then count the result set on a loop.

I can't use "SELECT COUNT(*) FROM (SELECT statement)" because COUNT(*) isn't eficient and can cause an overhead.

I'm doing some tests and if I reach an acceptable solution I will tell you.

Thanks,

Fábio R. Bot Silva.
KeyCode Tecnologia.