Dominik Fässler <[EMAIL PROTECTED]> said:
>
> The main problem is, that Firebird's API not supports db_num_rows(),
> respectively only rows affected on INSERT, UPDATE and DELETE (not on
> SELECT). For this reason i correct all files, which contains
> db_num_rows() with db_fetch_row() statements. I've translated almost
> all files expect dbmsgbuf.c. Most queries could be modified with
> statements like that:
>
> while ((row = db_fecth_row()) == 0) {
> ...
> }
>
Is this in place of using a for loop? It would work, but there might be
some code where memory allocations or other logic occurs on the basis of
the number of rows that were found. Just keep an eye out for such things.
There was a SQL intermediary library that we had been looking at a few
weeks ago, and if it already has Firebird support, your efforts would be
better spent writing a DBMail interface to that common backend:
http://libdbi.sourceforge.net/
Aaron
--
