too complicated, less readable and i guess consuming more
Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Thursday, August 17, 2017 9:17 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Evaluate "empty&qu
This is also possible
If (coalesce(terminal, '') <> '') then
Regards
Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Wednesday, August 16, 2017 6:39 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Ev
Hi
I haven't been working with Cobol for 25 years, but:
if Disconnect is in Procedure Division then Connect should also be there.
Regards Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Monday, July 3, 2017 7:28 AM
To: firebird
22.06.2016 8:44, 'Mihalache Bogdan' bogdan.mihala...@soter.ro
[firebird-support] wrote:
> - On the machines where the new values was not visible, i have
restarted the
> connection (Close the App and ReOpend it), but still the old value was
there, not the new one.
Most likely they are at
Hello!
We have a 64 bits firebirds 2.5.2 SC server on a linux machine. The stange
behavior that i don`t understrans is the following :
- I`ve Used Database WorkBench to update a value in a table from 0
to 1.
- I`ve commited the transaction and the new value was visible from
In firebird is there an option to declare a parameter in a stored procedure
as an IN/OUT. (like ORACLE server has)
http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/parameter_declaration.
htm
I want to send a parameter to a procedure, do some operation with it, and
return his new value.
select cast(extract(second from cast('12.12.2016 23:59:59:4900' as timestamp))
as integer) from rdb$database
59
On Wednesday, January 6, 2016 10:37 AM, "'Bogdan' bog...@mordicom.si
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
Hi all
I wonder if
Hi all
I wonder if this is an error or sql srandard:
select cast(extract(second from cast('12.12.2016 23:59:59:9000' as
timestamp)) as integer) from rdb$database
gives 60
Regards
Bogdan
---
Ta e-pošta je bila pregledana z Avast protivirusnim programom.
https://www.avast.com
Tnx
Regards
Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Wednesday, January 06, 2016 6:53 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Extract seconds from timestamp
On 06/01/16 08:37, 'Bogdan
If someone can help me.
I have a database with character set = none.
That happened by mistake when upgrading dialect 1 database from 1.5 to 2.5.
What is the procedure to change character set back to win1250 as it used to
be.
Any help will be appreciated.
Regards,
Bogdan
I wasn't aware of this.
I've assumed that if i = 0 Firebird looks only at the first part of the second
iif.
Thanks
Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Tuesday, August 25, 2015 11:47 AM
To: firebird-support@yahoogroups.com
3,4 5,2 2 11 3
Suma descending
Regards
Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Monday, August 24, 2015 6:26 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Error
11 1
Otherwise the sort order is ok.
This propagates only when there is iif within iif clause.
Am i doing something wrong or it is a bug ?
Best regards
Bogdan
= complete script:
SET SQL DIALECT 3
I believe there is no PK in the table, so engine doesn't know what record to
delete
Regards,
Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Tuesday, August 11, 2015 12:54 PM
To: firebird-support@yahoogroups.com
Subject: Re
) and
substring(x1 from e2 for 1) = substring(x2 from e1 for 1)) then
result = e1 || ' and ' || e2 || ' were swapped';
end
suspend;
end
Regards,
Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Wednesday
Are you running superserver ?
If so i would recommend switching to classic or superclassic
Regards
Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Thursday, March 12, 2015 8:06 AM
To: firebird-support@yahoogroups.com
Subject: Odp
Select trim(RC.RDB$INDEX_NAME)
from RDB$RELATION_CONSTRAINTS RC
where (RC.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY') and
(RC.RDB$RELATION_NAME = :TABELA)
into :PKTEMP
Using that select you can fiind the name of the column who has the primary
key.
Inspired from Carlos Cantu external log
Select trim(I.RDB$FIELD_NAME)
from RDB$RELATION_CONSTRAINTS RC
join RDB$INDEX_SEGMENTS I on (I.RDB$INDEX_NAME = RC.RDB$INDEX_NAME)
join RDB$INDICES IDX on (IDX.RDB$INDEX_NAME = RC.RDB$INDEX_NAME)
where (RC.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY') and
from ISQL and/or Flamerobin, or only
inside your application?
What is your own timezone, and what is the server timezone?
Mark
The last time i've seen such behaviour, we found there was another job
scheduled every 30 minutes
that took all the resources
Regards
Bogdan
---
avast
Manyou shlould read a bit more before going on this road. It a simple
example of select with group option.
Select TRANS_DATE,TRANSTIME, POSNUMBER, TRANSNUMBER, Count(ITEM_QTY) as
ItemsSold, SUM(LINE_TOTAL) as LineTotal from accounthistory
WHERE TRANS_DATE BETWEEN ' StartDate ' AND '
Hi
Why do you have RESERVE set to ON ?
Regards
Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of jakef...@yahoo.com
Sent: Tuesday, April 15, 2014 8:18 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support
Round(100/15.00) * 15
Or
(div(100,15)*15) + (cast((mod(100,15)/15.00) as Integer)*15)
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of checkmail
Sent: Tuesday, April 8, 2014 8:55 AM
To: firebird-support@yahoogroups.com
Subject:
Update table set column = Mod(column+1,2) where id = :id
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Mark Rotteveel
Sent: Wednesday, April 2, 2014 10:16 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] toggle betweenn
Statement Sql Into :lnCantitate ;
If i remove the variables(:lcIdContract, :lcIdRamura, etc.) from the sql
statement, that is stored in the table, it`s working, but I really need to
keep them, and keep the sql in the table. Does anyone has a solution to my
problem?
Bogdan MIHALACHE
is there an aproximate way to use this : execute statement
(sql) (parametes) ? or something similar to it? Has anyone tried something
like this? What was your aproach?
Thank you verry much!
Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf
This works just fine.
Thank you!(multumesc!)
Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Virna Constantin
Sent: Tuesday, March 4, 2014 1:03 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Select stored
I second this answer.
Regards,
Bogdan
MordiCom d.o.o.
i...@mordicom.si
+386 (05) 33 00 360
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Alexey Kovyazin
Sent: Tuesday, February 18, 2014 3:01 PM
To: firebird-support@yahoogroups.com
Why don`t you use CAST ( var as VARCHAR(NN)) ?
Bogdan MIHALACHE
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of liviuslivius
Sent: Friday, January 31, 2014 10:22 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Udf
Select * from TABLE_A aa where Exists (Select ab.id From table_b ab And
ab.data_b = 100 And aa.id = ab.id)
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of peter_...@yahoo.com
Sent: Monday, December 16, 2013 12:41 PM
To:
if(new.field_b0) and new.field_a = old.field_a then
dosomething;
else
dosomethingelse;
Original message
From: Dr. Fabrizio Villanova fvillan...@essedata.it
Date:
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Update query and trigger
hi all,
, or just snc
Regards Bogdan
[Non-text portions of this message have been removed]
.
Or am i missing something ?
Regards Bogdan
[Non-text portions of this message have been removed]
I second that
Regards Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann Harrison
Sent: Tuesday, October 30, 2012 3:36 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Parameterised like query won't use index
fdb name.
As I say before, this command work just fine in WinXp.
I would try:
gbak.exe -c -v -R -z -user sysdba -password masterkey d:\dbback\20120831.fbk
server:d:\dbback\rsdata.fdb
Regards Bogdan
[Non-text portions of this message have been removed]
I would check the data.
It seems like an old version of database .
Copy, system restore ??
Regards, Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Sofija Blazevski
Sent: Tuesday, August 07, 2012 4:07 PM
To: firebird-support
being hindered by the copy process.
It happens - corruption of the original fdb file when copying it - rare but
just once is too much.
Bogdan
[Non-text portions of this message have been removed]
are running something in a loop with AutoCommit
set to True?
Or maybe two events that trigger each other
Regards
Bogdan
[Non-text portions of this message have been removed]
avoid getting into trouble.
Regards
Bogdan
Probably beating a dead horse, but ...
On Wed, Feb 29, 2012 at 2:44 PM, todderamaa toddera...@yahoo.com
mailto:todderamaa%40yahoo.com wrote:
I have heard that you can corrupt a database when copying it with active
connections. I am wondering
Actually, active users stay connected to old renamed database.
It can happen only on linux, never on Windows.
Regards
Bogdan
Hi, I get your point.
But I wonder what can happen when we don't kill the existing clients before
restoring with the same database file name.
Actually I had a bad
Extract(day,month ... From ?date)
And then some ifs and etc
Regards, Bogdan
Lp, Bogdan
Sent from Win 7.5 mobile
-Original Message-
From: SoftTech
Sent: 26.1.2012 12:50
To: firebird-support@yahoogroups.com
Subject: [firebird-support] How do I convert a timestamp to a string from
within
test from test
where test starting with 'aaa_'
order by test descending
Presuming it is not always aaa_ in front of date part
Bogdan
* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/
* Upscene Productions - Database Tools for Developers
http
-Original Message-
From: Ann Harrison
Sent: 20. september 2011 17:44
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] How to put an entire Database in memory using
cache?
On Tue, Sep 20, 2011 at 10:17 AM, Alexey Kovyazin a...@ib-aid.com wrote:
Ann,
...
By
42 matches
Mail list logo