>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.
>>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
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
>>
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
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.
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
> 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
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
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
>
>
>
>
>> 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
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
11 matches
Mail list logo