Helen Borrie wrote:

> 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.

RC2 Super doesn't work on RedHat 6.2 (all utilities (isql, ibmgr) looking for GLIBC 2.2)
When I am saying "nested select" I don't mean few selects in one SQL statement.
I mean the case when we prepare (isc_sql_prepare) simple select (like "select * from <table>") after first fetch of result set from top level select (simple also).

>
>
> 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?
>

I thought if we use SS (like in my case) then the cache is on the server side.
But with the bug I describe memory grows on client side.
Am I wrong?

>
> 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
> _______________________________________________________
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Sincerely,

--
Lev Assinovsky Peterlink Web
Programmer St. Petersburg, Russia
Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7�
E-mail: lev@...




[Non-text portions of this message have been removed]