RE: [firebird-support] begin-end with different conditions

>Hello, > >is the following scenario possible (without a statement)? > >If inputvariable A is null then >For select b, c, d from table a >Else >For select b, c, d from table b (same fields like table a but different >informations (data)) > >Begin > >End > >The Block begin-and have the same code.

RE: [firebird-support] begin-end with different conditions

>>Hello, >> >>is the following scenario possible (without a statement)? >> >>If inputvariable A is null then >>For select b, c, d from table a >>Else >>For select b, c, d from table b (same fields like table a but different >>informations (data)) >> >>Begin >> >>End >> >>The Block begin-and have

AW: [firebird-support] begin-end with different conditions

Hello SET, thank you! >>Hello, >> >>is the following scenario possible (without a statement)? >> >>If inputvariable A is null then >>For select b, c, d from table a >>Else >>For select b, c, d from table b (same fields like table a but different >>informations (data)) >> >>Begin >> >>End >>

[firebird-support] Query is running slowly for the first time.

Hello guys. I am having problem with the query which is constructed like this: SELECT S.Column1, S.Column2, STORED_PROC.Column1, STORED_PROC.Column2 FROM TABLE SomeTable S LEFT JOIN STORED_PROC(S.UniqueID) ON 1=1 WHERE S.Data >= '01.07.2012' AND S.Data <='09.07.2012' Table SomeTable does not hav

[firebird-support] multiple instances

Hi Is it possible to run version 2.0 and version 2.5.1 simultaneously on windows? Also. I know windows 8 isn't officially out yet, but was Firebird running on the beta versions of windows 8? Thanks H.F.

RE: [firebird-support] Query is running slowly for the first time.

Bruce, > I am having problem with the query which is constructed like this: > > SELECT S.Column1, S.Column2, STORED_PROC.Column1, > STORED_PROC.Column2 FROM TABLE SomeTable S LEFT JOIN > STORED_PROC(S.UniqueID) ON 1=1 WHERE S.Data >= '01.07.2012' AND S.Data > <='09.07.2012' Is S.Data indexed? I

RE: [firebird-support] multiple instances

> Is it possible to run version 2.0 and version 2.5.1 simultaneously on > windows? Yes. The 2 versions would need to be installed in separate folders and configured to use/listen to 2 different TCP ports (ie. 3050 and 3051). > Also. I know windows 8 isn't officially out yet, but was Firebird

[firebird-support] Re: Query is running slowly for the first time.

Thank you Sean for trying to help. Unfortunately, that does not changed anything. I have indexed S.Data and number of records in table S is very small. I guess indexing does not really help anything here. I've tried your modyfication but the result is the same - slow for the first time, fast fo

[firebird-support] File size enlarge each time procedure is called

Hi, I have a database with around 7MB in file size. Inside there is a few procedures and one is giving me a headache. Inside of an procedure is a output variable type blob, where a few for-select-do loops are putting some data. There is no insert, update or delete in that procedure, just a few

Re: [firebird-support] multiple instances

> > > > >> Also. I know windows 8 isn't officially out yet, but was Firebird >> running on the beta versions of windows 8? > > I am not sure if anyone has tested on Win8. > > > I have Windows 8 and Firebird on my home PC, and so far haven't found any > issues

Re: [firebird-support] Query is running slowly for the first time.

Hello, > I am having problem with the query which is constructed like this: > > SELECT S.Column1, S.Column2, STORED_PROC.Column1, STORED_PROC.Column2 > FROM TABLE SomeTable S > LEFT JOIN STORED_PROC(S.UniqueID) ON 1=1 > WHERE S.Data>= '01.07.2012' AND S.Data<='09.07.2012' > > Table SomeTable does