RE: [firebird-support] SQL

What do you think about creating view? ( ex :viewAge ) and then we can write select * from viewAge where state='CA' De : firebird-support@yahoogroups.com de la part de Richard Damon rich...@damon-family.org [firebird-support] Envoyé : mercredi 28 août 2019

[firebird-support] Restore from .bak

Hopefully I am posting this to the correct group.  I am backing up a new Firebird database with SQLServerBooster (version 2.3.15). Windows Server 2012 R2.  It creates a .zip with a .bak inside.  I would like to test restoring from that to make sure it works.  I have no idea how to do that.

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

On 2019-08-30 04:33, Richard Damon rich...@damon-family.org [firebird-support] wrote: > On 8/29/19 3:14 PM, 'Alan McDonald' a...@meta.com.au [firebird-support] > wrote: > numeric(18, 3) will use a double for its internal representation, but I > would think it should still work. It might make more

Re: [firebird-support] MS-Windows<-->Linux compatibility

On 2019-08-29 13:06, emou...@yahoo.fr [firebird-support] wrote: > Hello, > > In theory, if I create a Firebird database with IBExpert under > MS-Windows, is it then possible to use it with a Linux application > (written in Lazarus), giving it all the right rights, ie without going > through an

AW: [firebird-support] Array datatype?

Oh, Alan, I’m using the extract-function. What do you use? select extract(weekday from current_date) from rdb$database – result is 5. Von: firebird-support@yahoogroups.com Gesendet: Freitag, 30. August 2019 09:01 An: firebird-support@yahoogroups.com Betreff: RE: [firebird-support]

AW: AW: [firebird-support] Converting with parameters stored in variables?

Hallo Karol, we have a rfc interface with a high bay storage an the telegram defines the different datatypes. If I would create a new material, I must set different parameters #name#weight…#111.111# and so on. Trunc instead of pow? Regards Olaf Von:

Re: {Disarmed} [firebird-support] MS-Windows<-->Linux compatibility

> In theory, if I create a Firebird database with IBExpert under > MS-Windows, is it then possible to use it with a Linux application > (written in Lazarus), giving it all the right rights, ie without going > through an IBExpert's script export and re-import into FlameRobin)? > IBExpert,

Re: AW: [firebird-support] Converting with parameters stored in variables?

Hi,You can do this simpler by using trunc.But i ask why do you need this format in resultset? Formatting numbers is a client side task, same as for DATE.Regards,Karol Bieniaszewski null

RE: [firebird-support] Array datatype?

Hello Alan, Im using now the extract function an there is 0 = Sunday, 1 = Monday I think. It’s Friday here today: select f_dayofweek(current_timestamp) from rdb$database returns 6

AW: [firebird-support] Converting with parameters stored in variables?

Hello Karol, yes, I know padding. In my case I would like to set the numeric parameters with two variables first. * Take the R11.3 into two variables f1 and f2 (f1 = 11, f2 = 3) * Set the numeric(:f1,:f2) without execute statements Now I have it realized as following:

AW: [firebird-support] Array datatype?

Hello Alan, Im using now the extract function an there is 0 = Sunday, 1 = Monday I think. Von: firebird-support@yahoogroups.com Gesendet: Donnerstag, 29. August 2019 09:23 An: firebird-support@yahoogroups.com Betreff: RE: [firebird-support] Array datatype? Hello Kjell,

AW: [firebird-support] Re: Array datatype?

Hello Vlad, thank you, I will revise my concept. Von: firebird-support@yahoogroups.com Gesendet: Donnerstag, 29. August 2019 09:26 An: firebird-support@yahoogroups.com Betreff: [firebird-support] Re: Array datatype? Use CASE: azeit = azeit + CASE EXTRACT(WEEKDAY