AW: [firebird-support] exponential, string to double precision

Hello András, so simple, thank you very much  -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Mittwoch, 28. Februar 2018 07:50 An: firebird-support@yahoogroups.com Betreff: RE: [firebird-support] exponential, string

RE: [firebird-support] exponential, string to double precision

Hi Olaf! Try this: select cast('+0.200E+01' as double precision) from rdb$database András From: firebird-support@yahoogroups.com [mailto:firebird-supp...@yahoogroups..com] Sent: Wednesday, February 28, 2018 7:44 AM To: firebird-support@yahoogroups.com Subject: [firebird-support]

[firebird-support] exponential, string to double precision

Hello, is there a simple function to convert a string "+0.200E+01" to a number, double precision, in this case to 2.0? Thank you Best regards Olaf

Re: [firebird-support] Re: Execute Block: Need Insert Into to trigger Primary Key generator.

Hi. Your trigger set FK_ID not PK_ID  Regards,Karol Bieniaszewski null

[firebird-support] Re: Execute Block: Need Insert Into to trigger Primary Key generator.

Sorry for the first example. I knew it didn't work. I accidentally copied it from an attempt that didn't work. I really meant to copy the second example but didn't catch my error until after I posted. When using the second example, the Primary Key is not updated which produces an error

AW: [firebird-support] Re: 335544382. Can't allocate difference page

Hi again, I had the error now again: 335544382. Can't allocate difference page I think that happened when I tried to execute ALTER DATABASE END BACKUP I also found the following in syslog: Feb 19 04:24:13 kernel:traps: firebird[16552] trap invalid opcode ip:7fabfa1bec19 sp:7fabd19c6950

Re: [firebird-support] Space used null values

On 27-2-2018 04:42, hugo.lar...@yahoo.com [firebird-support] wrote: > Does null values take up disk space? > > If I have a table with 4 VARCHAR columns and I add 4 more does the table > need double space even if the new columns are null? I recently answered this question on

[firebird-support] Re: Space used null values

27.02.2018 06:42, hugo.lar...@yahoo.com [firebird-support] wrote: > > Does null values take up disk space? Yes, but much less than the declared column size. > If I have a table with 4 VARCHAR columns and I add 4 more does the table > need double space even if the new columns are null? Already

Re: [firebird-support] Execute Block: Need Insert Into to trigger Primary Key generator.

On 27-2-2018 03:17, ho...@agencybusys.com [firebird-support] wrote: > Firebird 2.14,  Delphi 2007, Multi-User App, IBDac components. Why are you using 2.1.4? Version 2.1.4 has known security vulnerabilities (some of which are fixed in newer 2.1.x versions, some of which require you to upgrade