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'
>
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'
>
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
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),
>
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
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
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),
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),
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
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,
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
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
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
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
15 matches
Mail list logo