Hi,
Personally, I like mailing groups.
The speed of getting answers is much greater than on regular web forums.
At the beginning I was skeptical but I have been using this form for many years
and I see more pros than cons of this form of communication.
And as someone rightly stated, one can
But how timezone settup is configured in FB4?
Time zone is set in fbconfig (preffered) or is retrived from system?
If from config, then CURRENT_DATE and LOCAL_TIMESTAMP will get different date
when different timezone setting is in config and on the server.
regards,
Karol Bieniaszewski
From:
Hi,
is this your real query? I ask, because below WHERE can be not intentionaly
written by OR
WHERE (
heir.iaccttreeid = 47
AND cast(tsi.tdt AS date) < '2018-04-01' )
OR(
heir.iaccttreeid <> 47
AND
Hi,
returning ... INTO ..
regards,
Karol BIeniaszewski
From: talorigo...@yahoo.co.uk [firebird-support]
Sent: Sunday, June 10, 2018 1:14 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] stored procedured with insert ... returning
When I try to create the following
Hi,
better is walk throught tree
--
WITH RECURSIVE
R_TREE AS
(
SELECT TT.ID, TT.ID AS TOP_PARENT
FROM TABLE1 TT
WHERE TT.PARENT_ID IS NULL
UNION ALL
SELECT TT.ID, RT.TOP_PARENT
FROM TABLE1 TT JOIN R_TREE RT ON RT.ID =
>>As far as I can tell: no. I suggest you create a ticket to introduce
>>something like
>>ALTER TABLE ALTER EXTERNAL [FILE]
>>Mark
>>--
>>Mark Rotteveel
Thank you
created http://tracker.firebirdsql.org/browse/CORE-5834
regards,
Karol Bieniaszewski
Hi,
previously it was possible to change external table filename
UPDATE
RDB$RELATIONS r
SET r.RDB$EXTERNAL_FILE='c.txt'
WHERE
r.RDB$EXTERNAL_FILE='b.txt'
in FB3 it is prohibited.
Is there some DDL statment to alter such table only file name?
regards,
Karol Bieniaszewski
Hi,
few things:
1. instead FB3.0.3 use recent snapshot. It contain many fixes.
2. look at settings about buffers in your DB itself
if it utilize config then increase DefaultDbCachePages.
Currently you set it to only to 8GB – but db size is much bigger. Is this
server to serve only this
Hi,
as always RAM is crucial for DB, but with such size of DB you can only benefit
“a little”
I do not know the reall usage scenario – what data is used and how many data
are “analyzed” by normal user.
Does database contain historical data not comonly accessed or user “scan” whole
db every
Anyone can point me in some direction?
regards,
Karol Bieniaszewski
From: 'livius' liviusliv...@poczta.onet.pl [firebird-support]
Sent: Monday, May 21, 2018 9:35 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] PASCAL UDR - stored procedure BLOB param and return
Hi,
i
Hi,
i can work in udr with near to all types of params but
how can i work with blob as input parameter and output parameter
for stored procedure?
should this be as BLOB or something else?
InMessage = record
nr: Integer;
nrNull: WordBool;
dane: Blob;
daneNull:
>>That being s aid, I produced a technical paper a few days ago on my own
>>technical article site that I announced on this forum, which you may have
>>read. This article was designed with the intention of attracting other .NET
>>development professionals >>who have similar backgrounds to
>>I guess the reason is that user may have existing indexes on fields using the
>>domain. Changing the collate would need to have the indexes rebuilt,
>>otherwise they would be "corrupted". So, to avoid that, FB >>doesn't allow
>>such changes.
Yes, that can be the reason but i think something
Hi,
>>There is no way to change the default collation without dropping the domain
>>and recreating it with the desired attributes.
>>Perhaps tool like IBExpert could do this – alter and set collation? Not sure.
this was for FB2.5 where users could modify system tables but now in FB3 it is
Thank you botch Norbert and Dimitry for your help
problem was with fill method
the method is to use move index [1] of string and casting or StrLCopy
or simplest possible this one which does not require any casting:
StrPLCopy(outMessage.ss, s, High(outMessage.ss))
regards,
Karol Bieniaszewski
...@ibphoenix.com [firebird-support]
Sent: Monday, May 14, 2018 11:06 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Udr GenRows sample Pascal
14.05.2018 22:18, 'livius' liviusliv...@poczta.onet.pl [firebird-support]
wrote:
> maybe this is wrong?
> GenIntOutMessage =
Hi,
i am delphi developer but i never hear about CodeTyphon!
I hear about lazarus but not this one.
But i need to do this under Delphi (Win64).
I tried many things but i always got empty string.
Only integer work and null flag.
I tried GetMem, ib_util_malloc but maybe this is wrong?
Hi,
is there more complicated sample then current GenRows for Pascal?
Which return something more then only numbers?
I need to return char data of length 200.
Should i use PAnsiChar and allocate memory by ib_util_malloc?
How to declare this proc for such field Char(200) (Free it?)
regards,
.
regards,
Karol Bieniaszewski
From: 'livius' liviusliv...@poczta.onet.pl [firebird-support]
Sent: Friday, May 11, 2018 5:47 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Article for experienced developers looking
learn the Firebird Database
Hi,
article is quite
Hi,
article is quite good but the title is something like someone should not try to
read it..
regards,
Karol Bieniaszewski
From: blackfalconsoftw...@outlook.com [firebird-support]
Sent: Friday, May 11, 2018 4:52 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Article for
Hi,
You misunderstand execute statement
execute statement exdeute sql from e.g. variable and it can return data to INTO
INTO is outside of select sql text
e.g.
execute statement ‘select 1 from RDB$DATABASE’ INTO :MYPARAM
or
sql = ‘select 1 from RDB$DATABASE’;
execute statement(:sql) INTO
@yahoogroups.com
Subject: Re: [firebird-support] Alter column not null with constraint name FB3
On 24-4-2018 20:47, 'livius' liviusliv...@poczta.onet.pl
[firebird-support] wrote:
>
>
> >
> > Hi,
> > I need to add Field not null constraint with my custom name.
> > in previo
>
> Hi,
> I need to add Field not null constraint with my custom name.
> in previous versions of Firebird we can do:
> 1. ALTER TABLE XXX ADD FIELDX INTEGER CONSTRAINT NK_XXX__FIELDX NOT NULL;
>>Interestingly, that syntax is not documented in the Firebird 2.5
>>language reference.
it has been
Hi,
anybody can help with - point 4?
1. enable windows authentication is working ok by
CREATE GLOBAL MAPPING TRUSTED_AUTH
USING PLUGIN WIN_SSPI
FROM ANY USER
TO USER;
2. mapping specific windows domain user to internal Firebird user is working ok
by:
CREATE MAPPING TRUSTED_KBIENIASZEWSKI
Yes,
but remember about good join condition then and if needed sort condition
especially you can use system table e.g. RDB$RELATION_FIELDS (it contain many
records also in empty database)
and JOIN on RDB$RELATION_NAME=’RDB$DATABASE’ AND RDB$FIELD_ID=0 instead of
“G.OUT_NO=1”
regards,
Karol
Hi,
i know that you got the answer but, maybe this trick is interesting for you
because it is simplest for use in any query but require creation of one simple
procedure.
I use it always in situation like you with fixed numbers of rows with nulls
@yahoogroups.com
Subject: Re: [firebird-support] Firebird 3 Developer's Guide released
On 3-3-2018 13:16, 'livius' liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> thank you very much for this guide.
> Where should i post info if i heve finded some issues in text? Here?
That i
Hi,
Did you tested this fix?
It was included in
https://github.com/FirebirdSQL/firebird/commit/9c66f3c8d018e9256042f7ad210562c93426a55c
but you have not confirmed if this commit fix your problem on the tracker.
Regards,
Karol Bieniaszewski
From: Rudi Feijó rudi.fe...@multidadosti.com.br
is the same for all connections!
Il 10 feb 2018 16:46, "'livius' liviusliv...@poczta.onet.pl [firebird-support]"
<firebird-support@yahoogroups.com> ha scritto:
Hi,
you store in your persistent table login (user_name) it is presistent
information.
You join your
Hi,
you store in your persistent table login (user_name) it is presistent
information.
You join your persistent table which should contain login name and you join
your persistent table with mon$attachment an you know who is currently logged
in.
once again sample
CREATE TABLE MY_USERS
I know that you solved your problem.
But why you store ID from your custom table into context var
not oposite USER_NAME in your custom user table? Then you do not need var at
all.
regards,
Karol Bieniaszewski
From: marco andreolli dra...@gmail.com [firebird-support]
Sent: Monday, February 5,
Hi,
what problem with MON$ATTACHMENTS? There you have info who is logged and from
where.
you have:
- user
- IP + port
- application name
- Remote PID (process ID)
what more you need? You can bind user name with your “user” by some table.
If you really need more info, create table with
Hi,
if you need only one record then why do you use GROUP BY?
GROUP BY divide your resultset into defined groups.
Remove whole GROUP BY and acquire sum from whole records as 1 record result
regards,
Karol Bieniaszewski
From: m_brahi...@yahoo.fr [firebird-support]
Sent: Monday, December 25,
Hi,
same no, but similar yes
select decode(1, 0, 'deleted', 1, 'active', 2, ‘inserted’, null) from
RDB$DATABASE
regards,
Karol Bieniaszewski
From: zilez2...@yahoo.com [firebird-support]
Sent: Friday, November 24, 2017 3:12 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support]
Hi,
bitness of the server does not matter only bitness of client library
(fbclient.dll).
Client library bitness must be the same as your application.
regards,
Karol Bieniaszewski
From: m_brahi...@yahoo.fr [firebird-support]
Sent: Tuesday, November 14, 2017 5:54 PM
To:
Hi,
what about this?
with recursive cte as
(select M.id, M.id_parent, M.green, CAST(M.SortText AS VARCHAR(100)) AS
SortText
from MyTable M
where M.Green = 'Yes'
union all
select T2.id, T2.id_parent, T2.green, T2.SortText || '->' || C.SortText
from MyTable T2
join
Hi,
client port number
regards,
Karol Bieniaszewski
From: m_brahi...@yahoo.fr [firebird-support]
Sent: Tuesday, October 31, 2017 8:07 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] MON$REMOTE_ADDRESS
Hello,
Can you please, tell what mean the second part number of
Hi,
this is normal sql behavior
if you do not need to implicit INNER JOIN condition then move filter to left
join itself
in your situation:
instead “where mytable.id is not null” write “ AND mytable.id is not null”
...
select aux.n, mytable.id
from aux
LEFT JOIN mytable on aux.n between
Hi,
what about this query
It looks strange but is really simple
SELECT
R5.SUMING, COUNT(*)
FROM
(
SELECT
(SELECT CAST(LIST(R3.ROUTE_INDEX || '_' || R3.LINK_NODE) AS VARCHAR(1000)) AS
SUMING FROM (SELECT * FROM ROUTES R4 WHERE R4.NODE=R2.NODE ORDER BY
R4.ROUTE_INDEX ASC) R3), R2.NODE
FROM
Hi,
without any sample you talking about nothing..
Show some sample which can be reproduced.
Without this i can say same Firebird is faster then Oracle and what someone can
say about this – nothing
regards,
Karol Bieniaszewski
From: zilez2...@yahoo.com [firebird-support]
Sent: Thursday,
Hi,
look on this, only simple sample, by if join count increase you will see
difference faster.
Also faster if you join by few fields not only one.
At first look you see clearly where is filter and where is join condition.
And then you can simply analyse if query use indexes on joined fields and
Hi,
show View (M_FNGD_VW) definition
and also what are the settings – especially PAGE buffers and Page size in both
2.5 and 3
regards,
Karol Bieniaszewski
From: trsk...@yahoo.com [firebird-support]
Sent: Friday, September 22, 2017 11:05 AM
To: firebird-support@yahoogroups.com
Subject:
Hi,
this is terible to read. Please change join style to explicite join style
instead SELECT .. FROM TABLE_A A, TABLE_B B WHERE A.ID=B.ID
write SELECT .. FROM TABLE_A A INNER JOIN TABLE_B B ON A.ID=B.ID
regards,
Karol Bieniaszewski
From: trsk...@yahoo.com [firebird-support]
Sent: Friday,
Hi,
i do not remember your previous description
but did you checked your DB against corruption?
gfix –validate –full
any errors (also in firebird.log)?
Did you performed backup/restore process.
Do you use any udf? also system udf?
Do you have enough free mem, free disk space also for temp files
>>Karol,
>>I was referring to the default transaction state of snapshot (repeatable
>>read)
>>Other transaction states will have different effects. In your case
>>read commited needs only the newest record version (or record versions
>>created by
>>the transaction itself) so its not going
> I read somewhere that the "read only" transactions are absolutelly harmless
> to the GC and sweeping. Is that so?
>>Read only transactions only physically have an impact on the TIP/Header
>>page(s), however a long running read only transaction
>>will have the same effect as a long running
Hi,
will be better to show sample script
create table
and insert into..
and db charset
then anyone can test this self
regards,
Karol Bieniaszewski
From: eadbha...@yahoo.com.mx [firebird-support]
Sent: Monday, September 4, 2017 7:34 PM
To: firebird-support@yahoogroups.com
Subject:
Hi,
this is the feature – key is only valid(checked) for values but null is not
“value”.
This work same in all databases i have worked.
regards,
Karol Bieniaszewski
From: Paweł Świerzko p_swier...@poczta.onet.pl [firebird-support]
Sent: Wednesday, August 9, 2017 3:21 PM
To:
Hi,
put fbclient.dll / and/or/ gds32.dll into your application folder.
Remember that you need 32bit dll’s if your app is 32bit and 64bit dll if you
have 64bit app (bitness of the server does not matter)
Check if you have not Interbase installed on you computer side (some apps can
install it)
Hi,
thank you Vlad for clarify
I have created ticket http://tracker.firebirdsql.org/browse/CORE-5577
regards,
Karol Bieniaszewski
From: hv...@users.sourceforge.net [firebird-support]
Sent: Thursday, July 6, 2017 12:05 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support]
Hi,
> 2. Page is read/write beacause of big sort operation
>> Sort IO is directed into separate temporary files and it is nor cached by
>> the engine, nor paged.
>> Unfortunately, engine doesn't collect Sort statistics.
Will be good to see this on trace output and accumulated stats on
Hi,
>>practical benefit to breaking up triggers?
1. separate code logically like procedure
2. you can simply disable it without altering content
3. simplify editing by minimize toxicity
regards,
Karol Bieniaszewski
-Oryginalna wiadomość-
From: Gabor Boros mlngl...@bgss.hu
>>Why should it be forbidden? Not everything that's dumb is disallowed.
Because it can cause problem if someone do this not intentionally.
Also if your system must work with many databases it is then not compatibile.
(e.g. not compatibile with MSSQL)
regards,
Karol Bieniaszewski
From: Ann
>>At DDL time: What happens if you flip the used data types for ID/ID1?
No difference – constraint created
regards,
Karol Bieniaszewski
From: Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Sent: Monday, June 19, 2017 7:21 PM
To: firebird-support@yahoogroups.com
Subject: Re:
To be more precised – Interbase(and IBX) support boolean datatype but only
Interbase implementation
not Firebird implementation.
regards,
Karol Bieniaszewski
From: Tony Christiansen t...@adegroup.com.au [firebird-support]
Sent: Wednesday, May 24, 2017 1:07 AM
To:
Hi,
first what do you mean it contain array of boolean
you mean e.g 5 bytes and first byte is first boolean, seconf byte is second
boolean..?
And for this you probably need udf or convert to string
regards,
Karol Bieniaszewski
From: maartenjanbak...@gmail.com [firebird-support]
Sent:
Hi,
first potential thing – transaction management.
Probably you have transaction long running and it stop garbage collector to
process old record versions
Look into MON$TRANSACTIONS
regards,
Karol Bieniaszewski
From: craig_...@coxcolvin.com [firebird-support]
Sent: Thursday, May 4, 2017
Hi,
first try to upgrade to recent Firebird version
i recomend you snapshot
http://web.firebirdsql.org/download/snapshot_builds/win/3.0/
but you can also try official
https://www.firebirdsql.org/en/firebird-3-0-2/
after that if you will have also problems – back here
regards,
Karol
particullary filter
data then it should be prefered :)
regards,
Karol Bieniaszewski
From: 'livius' liviusliv...@poczta.onet.pl [firebird-support]
Sent: Saturday, February 18, 2017 8:30 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Firebird 3 execution plan
>
>>Separately, I am not aware that FireMonkey/Delphi can be deployed as mobile
>>apps if they require external DLLs. AFAIR, FireMonkey apps must be built from
>>"native" code.
FireMonkey apps are builded into native code. Firemonkey can work with external
dll
but i do not know if FBclient for
:(
From: "'livius' liviusliv...@poczta.onet.pl [firebird-support]"
<firebird-support@yahoogroups.com>
To: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]"
<firebird-support@yahoogroups.com>
S
Hi,
as Dmitry say problems can be already solved in snapshot build
e.g. http://tracker.firebirdsql.org/browse/CORE-5307 can be same as your
problems –
use napshot build from
http://www.firebirdsql.org/en/snapshot-builds/
regards,
Karol Bieniaszewski
From:
Hi,
your statement is incorrect
select count(* )
should by after autonomous transaction commit not inside it
if it is in the same transaction then garbage collector cannot remove versions
and also i do not suppose that
delete from requests where created < :delete_all_before rows 1000;
is
08.07.2016 15:41, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> Blobs: 1976786, total length: 37039763, blob pages: 0
> Level 0: 1976786,
>> All BLOBs are level 0, they are kept on data pages with other record
>> data. No separate
>>BLOB pages.
>>--
>> WBR,
Hi,
error message?
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Thursday, June 23, 2016 6:39 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] It works on FB 2.5 but does not work in FB 1.5
I created a view that works perfectly on FB
pluses?
Firebird has no support for schemas, IIRC... or am I missing something?
Em dom, 12 de jun de 2016 às 18:18, 'livius' liviusliv...@poczta.onet.pl
[firebird-support] <firebird-support@yahoogroups.com> escreveu:
Hi,
what are + and – with working with schema?
What be
Hi,
thank you Dmitry – the last sentens show me some benefits
other sentenses show only complications for me.
we can write sql like
select * from table_name but really this is
select * from schema.table_name
and if i write this in stored procedure – i suppose that “object_id” will be
stored in
Hi,
do you mean that you share one connection between multiple threads?
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Wednesday, June 15, 2016 5:55 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] performance issue with firebird 3.0
Hi,
what are + and – with working with schema?
What benefits are between
schema_name__table_name and real schema implementation?
schema_name.table_name
I near to always have worked without schema databases or with only one schema
in schema supported databases.
regards,
Karol Bieniaszewski
Hi,
thanks you Paul
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Thursday, June 9, 2016 11:03 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] FOR UPDATE [OF ...]] WITH LOCK
<>
"The clause can take an optional OF to target
Hi,
you must convert any procedure - for which you need plan - to execute block
format
if you are interested in plan for proc 1 then you need proc 1 execte block
if this proc1 use proc2 you need to make proc2 as execute block..
regards,
Karol Bieniaszewski
From:
Hi,
thanks you and others for correction
now “44” i am near to understand.
45. i must test – but how look sort for your sample?
ORDER BY T1.iSort
and difference is because of existence of big varchar - BIGSTARTING ?
If yes then something must be wrong – this sould only sort pointers and
72 matches
Mail list logo