05.01.2018 18:09, HuI HaO huihaoc...@hotmail.com [firebird-support] wrote:
> currently i have an application at client side runing a timer 5s keep do the
> select sql
> read the Table as status on server DB. after few day run the fb service hang
> up and slow
> respond the DB file size also inc
Hallo,
Il 04/01/2018 21.57, setysvar setys...@gmail.com [firebird-support] ha
scritto:
I expect the following query to give you the result
you want:
...
Yes.
I think I understand your query and I'll treasure it for the next time.
Thanks so much.
--
Luigi Siciliano
Dear
currently i have an application at client side runing a timer 5s keep do the
select sql read the Table as status on server DB. after few day run the fb
service hang up and slow respond the DB file size also incease
any solution?
From Hugo Chia
Hi All,
Sorry for the repost, but it's been a year
We have tcpsvd binding fb_inet_server processes to different port/address/root
combinations but sharing a tmpfs lock folder and security2.fdb on the same
server. Reading and writing to security2.fdb seems to be about the only
signifi
I use FOR SELECT in some part of the DB but the problem is when I use multiple
criteria for example for the same table order order_date, order_no, etc...
then I had to use execute statement to build query for each criteria. According
to your advise, do I need to build the SP with FOR SELECT and
On 5-1-2018 14:35, m_brahi...@yahoo.fr [firebird-support] wrote:
>
>
> Now with
>
> V1=:V1 || ' WHERE CF.DATE_COMMANDE'||' BETWEEN '''||:FROM_DATE||''' AND
> '''||:TO_DATE||;
>
> It works for me and I tried with
>
> V1=:V1 || ' WHERE CF.DATE_COMMANDE>='''||:FROM_DATE||''' AND
> CF.DATE_
Anyway, as it solved thanks to all
Now with
V1=:V1 || ' WHERE CF.DATE_COMMANDE'||' BETWEEN '''||:FROM_DATE||''' AND
'''||:TO_DATE||;
It works for me and I tried with
V1=:V1 || ' WHERE CF.DATE_COMMANDE>='''||:FROM_DATE||''' AND
CF.DATE_COMMANDE<='''||:TO_DATE||;
It works too. In which case this isn't the
On 5-1-2018 13:23, m_brahi...@yahoo.fr [firebird-support] wrote:
> Thanks but adding a quote at the end doesn't work. In fact adding double
> quote because with one the SP will not be compiled
That is because || '; would open a string but not end it, then ||'';
doesn't work, because that is jus
On 5-1-2018 13:37, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> Your immediate problems is caused by missing quotes around the date
> values though.
Specifically, it would need to be:
V1=:V1 || ' WHERE CF.DATE_COMMANDE'||' BETWEEN '''||:FROM_DATE||''' AND
'''||:TO_DATE||;
On 5-1-2018 12:52, m_brahi...@yahoo.fr [firebird-support] wrote:
> I am using FB 3 and IBExpert and with the DDL below I get message
> command> and it works when I remove the where clause. I think the
> problem is with the between command. Can you please help me ?
Why are you using `execute sta
Thanks but adding a quote at the end doesn't work. In fact adding double quote
because with one the SP will not be compiled
Normally, a query would contain something like:
WHERE CF.DATE_COMMANDE BETWEEN '1.1.2018' AND '2.1.2018'
What you are doing is forgetting the apostrophes and trying to use:
WHERE CF.DATE_COMMANDE BETWEEN 1.1.2018 AND 2.1.2018
which correctly receives a syntax error.
I can think of three ways t
Hi,
I think there is a quote missing at the end of ":TO_DATE";
Regards
Martin
Hi all,
I am using FB 3 and IBExpert and with the DDL below I get message and it
works when I remove the where clause. I think the problem is with the between
command. Can you please help me ?
create or alter procedure test_commande (
from_date date,
to_date date)
returns (
15 matches
Mail list logo