At 04:43 PM 11-02-02 +0300, you wrote:

>Thank you, Helen!
>Sure I will try RC2 as soon as I find RedHat 7.2 box.
>(Shouldn't Firedbird supports both RedHat6.2 and 7.2 as the most stable versions?)

It should and, so far as I know, it does. I had Beta2 Classic installed on RH 6.2 and I now have RC2 Classic on RH 7.2. I've had a few problems with 7.2 but not with respect to Firebird. I've had no trouble with DSQL or stored procedure calls so far, certainly no sign of leaks in the API.

I was trying to work out what was going on in your code but my knowledge there is defective. (I'm a Pascal programmer, only semi-demi literate in C). Alarm bells rang when you mentioned "nested selects", since Firebird doesn't support them. I'm more at home with SQL and I haven't seen an SQL statement yet. Possibly in this list we can get to the crux of the problem if we have a statement to look at...albeit you haven't reported that your statement doesn't work.

>Also I didn't get how is db cache related to API?

DB cache is related to memory, though, and it grows differently depending on whether you are using Classic or Superserver. Basically, if this was an API bug, we would surely know about it already, since all applications (except embedded SQL) work through the API and here we are all application developers. So I'm saying if you want to get resolution, you need to close some gaps in the information you provided.

Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________