[firebird-support] memory bug?

2019-08-27 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
Hello, we are using firebird 3.0.1 Superserver 32 Bit on a Windows Server 2008 32 Bit. Currently we have all 60 days the problem, that our Applications works not well, the firebird-process uses almost 2GB of RAM and this is seemingly the limit of an 32 Bit process. In this case, I cannot

ODP: [firebird-support] memory bug?

2019-08-27 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
Hi >>we are using firebird 3.0.1 Superserver 32 Bit on a Windows Server 2008 32 >>Bit. First, why 3.0.1 it contain many bugs fixed already. Use official 3.0.4 or snapshot version. >>Currently we have all 60 days the problem, that our Applications works not >>well, the firebird-process uses

Re: [firebird-support] Is this a bug in ROUND function?

2019-08-27 Thread Richard Damon rich...@damon-family.org [firebird-support]
On 8/19/19 4:46 AM, m.djo...@gmail.com [firebird-support] wrote: >   > > The following query shows that ROUND function does not give similar > results for similar values: > > > select >     round(cast(0.725 as double precision), 2), >     round(cast(1.725 as double precision), 2), >    

[firebird-support] Error code help

2019-08-27 Thread Todd Pickler t...@midlandsxray.com [firebird-support]

[firebird-support] Performance of deleting records based on another table

2019-08-27 Thread Joost van der Sluis jo...@cnoc.nl [firebird-support]
Hi all, I finally realized today that I do not know how to properly remove records based on another table. Suppose I have two tables, one with data (called BIG), and one table (SMALL) with only some id's that has to be removed from the BIG-table. I cannot get this to work, without having

[firebird-support] SQL

2019-08-27 Thread mohamed hamza medh...@hotmail.com [firebird-support]
Hi All, I am new to sql, I am coming from Xbase system . I want to know if it 's possible to execute query using last query result? EXAMPLE 1 select * from persons where state='CA' 2 select * from persons where age> 18 but we have to use the result of 1 I DO NOT WANT TO DO AN

[firebird-support] Is this rounding normal?

2019-08-27 Thread m.djo...@gmail.com [firebird-support]
I've just noticed that the ROUND(X, 2) function have a little problem. The results from this query SELECT ROUND(CAST(0.725 AS DOUBLE PRECISION), 2), ROUND(CAST(1.725 AS DOUBLE PRECISION), 2), ROUND(CAST(2.725 AS DOUBLE PRECISION), 2), ROUND(CAST(3.725 AS DOUBLE PRECISION),

[firebird-support] Is this a bug in ROUND function?

2019-08-27 Thread m.djo...@gmail.com [firebird-support]
The following query shows that ROUND function does not give similar results for similar values: select round(cast(0.725 as double precision), 2), round(cast(1.725 as double precision), 2), round(cast(2.725 as double precision), 2), round(cast(3.725 as double precision), 2),

[firebird-support] Help please

2019-08-27 Thread mike Southwood msouthw...@gmail.com [firebird-support]
I have just tried to download the Firebird database software onto my Mac High Sierra. It went through the whole installation and after I quit it wasn’t in any folders. I restarted the Mac and found it on my login password page requiring a password. Any ideas on how I can remove this completely

[firebird-support] Performance of deleting records based on another table

2019-08-27 Thread Joost van der Sluis jo...@cnoc.nl [firebird-support]
Hi all, I finally realized today that I do not know how to properly remove records based on another table. Suppose I have two tables, one with data (called BIG), and one table (SMALL) with only some id's that has to be removed from the BIG-table. I cannot get this to work, without having

[firebird-support] "could not convert variant of type (null) into type (currency)"

2019-08-27 Thread Ernst van Gooswilligen erns...@msn.com [firebird-support]
Good day I get "could not convert variant of type (null) into type (currency)" error on client connected to server from a specific laptop on any "firebird" user in the program that utilises Firebird (not different windows users) Is this a windows setting causing the problem (region, language,

Re: [firebird-support] SQL

2019-08-27 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Den 2019-08-05 kl. 13:20, skrev mohamed hamza medh...@hotmail.com [firebird-support]: > > Hi All, > >   I am new to sql,  I am coming  from  Xbase  system . >  I want to know if it 's  possible to execute query using last query > result? > > EXAMPLE > 1  select * from persons where state='CA' >

Re: [firebird-support] Performance of deleting records based on another table

2019-08-27 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Den 2019-08-17 kl. 12:51, skrev Joost van der Sluis jo...@cnoc.nl [firebird-support]: > > Hi all, > > I finally realized today that I do not know how to properly remove > records based on another table. > > Suppose I have two tables, one with data (called BIG), and one table > (SMALL) with only

Re: [firebird-support] SQL

2019-08-27 Thread Richard Damon rich...@damon-family.org [firebird-support]
On 8/5/19 4:20 AM, mohamed hamza medh...@hotmail.com [firebird-support] wrote: >   > > Hi All, > >   I am new to sql,  I am coming  from  Xbase  system . >  I want to know if it 's  possible to execute query using last query > result? > > EXAMPLE >    > 1  select * from persons where state='CA' >

Re: [firebird-support] memory bug?

2019-08-27 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-08-27 14:31, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > we are using firebird 3.0.1 Superserver 32 Bit on a Windows Server > 2008 32 Bit. Currently we have all 60 days the problem, that our > Applications works not well, the firebird-process uses almost 2GB of > RAM and