Re: [firebird-support] Upgrade from superclassic to superserver

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

Re: [firebird-support] Choosing best server / processor for Firebird 3.03 64 bits database on Windows server 2016 64 bits

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

Re: [firebird-support] PASCAL UDR - stored procedure BLOB param and return

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

[firebird-support] PASCAL UDR - stored procedure BLOB param and return

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:

Re: [firebird-support] Firebird ADO.NET: ExecuteNonQuery Returns -1 On Successful Insert

>>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

Re: [firebird-support] FB3 alter domain colltion

>>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

[firebird-support] FB3 - no permission for SELECT access to TABLE PLG$SRP

Hi,   can you help me fix below problem?   when connected user try to select on SEC$ for data  he got an error:     find/display record error no permission for SELECT access to TABLE PLG$SRP.   - e.g. SELECT U.SEC$USER_NAME , (SELECT

Re: Re: [firebird-support] FB3 alter domain colltion

>>It is not clear why you included a COLLATE clause in an ALTER DOMAIN >>statement. You can't change the COLLATE property of a domain, which >>is why you got the error: COLLATE is not expected in an ALTER DOMAIN >>statement. But you were not trying to change that, anyway. >>HB The question is why

Re: [firebird-support] FB3 alter domain colltion

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

Re: [firebird-support] Re: Udr GenRows sample Pascal

From: liviuslivius liviusliv...@poczta.onet.pl [firebird-support] Sent: Tuesday, May 15, 2018 11:19 AM To: firebird-support@yahoogroups.com Subject: Re: Re: [firebird-support] Re: Udr GenRows sample Pascal > It depends on information in IMessageMetadata. > > > I have tried: >

Re: [firebird-support] MON$Attachment privileges

Hi, thank you. I see that in FB3 this is the only way :(This break logic in our application. Regular user ca not have privileges to change db structure but with RDB$Admin role he can :(I see that this is implemented only in FB4tracker.firebird.org/browse/CORE-2557 Regards,Karol Bieniaszewski

Re: Re: [firebird-support] Re: Udr GenRows sample Pascal

>It depends on information in IMessageMetadata. > > > I have tried: > > ss: Array[0..199] of Char; > > ss: Array[0..199] of Byte; > > ss: Array[0..199] of AnsiChar; > >This is a right declaration for CHAR(200). > OK > > ss: String[200]; > > > > with last string[200] i got result

[firebird-support] MON$Attachment privileges

Hi,   how can i grant select on MON$Attachements to normal user that he/she can see all attachements not only self?   I use Firebird 3.   regards, Karol Bieniaszewski

Re: [firebird-support] Re: Udr GenRows sample Pascal

...@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 =

Re: [firebird-support] Re: Udr GenRows sample Pascal

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?

[firebird-support] Udr GenRows sample Pascal

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,

Re: [firebird-support] Doubts regarding statistics of indexes and tables...

Hi, i do not suppose that this is possible and especially that you should do this. Better then look at queries and addapt it to real situation. Regards,Karol Bieniaszewski null

Re: [firebird-support] Doubts regarding statistics of indexes and tables...

Hi, to "backup" statistics you can run query on rdb$indices and rdb$index_segment tables. And save result to the file. About table statistics - here is really fine concept that you do not need to recalculate anything. Table pages count and record size is taken in calc. In fb3 also record

Re: [firebird-support] Article for experienced developers looking learn the Firebird Database

. 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

Re: [firebird-support] Article for experienced developers looking learn the Firebird Database

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

Re: [firebird-support] Re: Firebird temp files

>>Either some GTT was used or temporary >>blob storage was requested. Why do >>you want it to be prevented? RAM is fast disc is slow and i have plenty of free RAM. Also i have bigger cache then database pages count and this operations can be all done in memory. >>In SS, it will be

RE: [firebird-support] Subscribe and question

Ar you sure that your answers are true?You say that win10 is only a clien and then that when you restore to update 1709 you see that fb is listen. I suppose you have Firebird installed on this Win10 machine and it serve client and server in the same time. Is this true or your config os

Re: [firebird-support] Re: Firebird temp files

Yes, you have right  but i really try to avoid RAM disc which consume memory always i prefer if some resource free memory it is available to be consumed by any process.  Do you know why this file is created at all and especially why its handle is still active in firebird process few days?

[firebird-support] Monitoring tables indexes

Hi, can i ask why monitoring tables have not any indexes? Any left join go into natural scan as we have not hash/merge for outer join (core-4823). Regards,Karol Bieniaszewski

RE: [firebird-support] Re: Firebird temp files

Hi, Thank you for the suggestion. We will consider RAM disc uses but first we must be sure how big it should be to catch all cases. It should be docummented how temp tables work (maybe it is somwhere?) with temp files. Regards,Karol Bieniaszewski null

Re: [firebird-support] Re: Firebird temp files

Ok, i understand temp file caching but why Firebird create this temp file at all and how to prevent this? And second question, why file handle is still active? Is this file for particular temporary table or it is a buffor for all temporary tables? Regards,Karol Bieniaszewski null

Re: [firebird-support] Re: Firebird temp files

>> No, caching is left up to OS. i do not understand above. I have dissabled os caching in firebird.conf. Also file is created by Firebird not OS. Can you explain this more? Regards,Karol Bieniaszewski null

Re: [firebird-support] Re: Firebird temp files

Thank you for the info Is there particular settings to go always into RAM or some buffer settings which i can increase to avoid going to disc? I have nowTempCacheLimit = 800MMentioned file is 29MB in size and dated 2 days old and its handle is still in use by Firebird process Regards,Karol

[firebird-support] Firebird temp files

Hi, what is the purpose of temp file named e.g.fb_table_yfz4x5?I use FB3 regards,Karol Bieniaszewski

Re: [firebird-support] Strange SIMILAR TO result

Ach now it is clear. All work ok. You got false for char(5) because it work the same way as it is working for LIKE with char.  TrySelect cast('ABCD' as char(5)) like 'ABCD' from rdb$database Regards,Karol Bieniaszewski null

Re: [firebird-support] Strange SIMILAR TO result

Hi, It is false for meBut i put '=' in single quote with double it does not work. I use FB3.0.4.32954 dialect 3 Regards,Karol Bieniaszewski null

Re: [firebird-support] Dynamic PSQL (Execute Statement) in Stored Procedure With "SELECT / INTO"

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

Re: [firebird-support] Alter column not null with constraint name FB3

@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

Re: [firebird-support] Alter column not null with constraint name FB3

> > 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

[firebird-support] Alter column not null with constraint name FB3

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; 2. UPDATE TABLE XXX SET FIELDX=some calculations;   Now in Firebird 3 this is prohibited on table with data.  

Re: [firebird-support] Write UDF for 3.0 - Linux 64bit vs Windows 32bit

Hi, I do not work with linux buDid you compiled it as 64bit? And is your Firebird server 64bit? Regards,Karol Bieniaszewski null

Re: [firebird-support] Book on T-SQL

Hi Steve, can you point me into one example about sentence mentioned by you"Firebird's implementation of SQL is a very strict implementation of the SQL-92 Standard.  As a result, this makes Firebird-SQL not only very limited in what it can do when compared to other SQL dialects but extremely

Re: [firebird-support] Can't connect to Linux FB 2.5 remotely

Hi, What if you do not ommit servername on server side? Is this working? If not then service is not running or fbconfig have only local connections plugin set (if it is Firebird 3) Regards,Karol Bieniaszewski Oryginalna wiadomość Od: "dco...@sympatico.ca [firebird-support]"

[firebird-support] Re: Mapping Windows group to FB role

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

[firebird-support] Mapping Windows group to FB role

Hi, can someone point me how can i map windows group to the Firebird role?I have tried already CREATE MAPPING TRUSTED_WSZYSCY USING PLUGIN WIN_SSPI FROM predefined_group 'rFirebird-Firebird-DBRido-ReadWrite' TO ROLE WSZYSCY I have also tested with prefix xcorp\rFirebird... mapping was created

Re: [firebird-support] Firebird3 Autentication

rt windows auth? Regards,Karol Bieniaszewski Oryginalna wiadomość Od: "liviuslivius liviusliv...@poczta.onet.pl [firebird-support]" <firebird-support@yahoogroups.com> Data: 26.03.2018 11:23 (GMT+01:00) Do: firebird-support@yahoogroups.com Temat: [f

[firebird-support] Firebird3 Autentication

Hi, in Firebird 2.5 there was Autentication parameter in Firebird.conf. It have values like NATIVE, MIXED or TRUSTED. I do not see it in Firebird3 firebird.conf. Can someone point me to the right config? Regards,Karol Bieniaszewski

Re: [firebird-support] select *at least* N rows

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

Re: [firebird-support] select *at least* N rows

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

Re: [firebird-support] FB3.0.2 : Lost one record (update on power off ?)

Hi, Firebird uses carefull writes but this have less importance today bacause below are array buffers, disc buffers and system buffers. But what was in firebird.log when you run gfix -validate -full on that database before you backup it and restore? Regards,Karol Bieniaszewski null

Re: [firebird-support] Re: Can many Execute Blocks be within a Transaction.

Hi, One transaction have benefits like integrity. If your process must be accomplished as a whole it is only good way for this. Your statments are executed serial. For parallel you will need many connections at the same time. Regards,Karol Bieniaszewski null

Re: [firebird-support] Execute Block size limit

Yes, limiting number of inserts can help but. What kind of connectivity components are you using? If firedac, then look at array dml. It make prepared execute block for you and i can get performance e.g 200 000 records per second. You have small record sets to import, then write insert one by

Re: [firebird-support] Firebird 3 Developer's Guide released

@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

Re: [firebird-support] Re: Execute Block: Need Insert Into to trigger Primary Key generator.

Hi. Your trigger set FK_ID not PK_ID  Regards,Karol Bieniaszewski null

Re: [firebird-support] Trying to figure out if CORE-5615 is on fb 3.0.3

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

Re: [firebird-support] Foreign Key & Query Performance

Show query plans for both situatios fk an index. Regards,Karol Bieniaszewski Oryginalna wiadomość Od: "antoedinchar...@gmail.com [firebird-support]" Data: 24.02.2018 11:40 (GMT+01:00) Do: firebird-support@yahoogroups.com Temat:

[firebird-support] No permission to remote access to database

Hi, How to add permission to login into security3.fdb? regards,Karol Bieniaszewski

Re: [firebird-support] Re: SecurityDatabase in FB3

And if i understand corectly you can have different users acros databases and different users properties Regards,Karol Bieniaszewski null

Re: [firebird-support] Re: Set custom value on connection system info

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

Re: [firebird-support] ODS Error Help

Check your system32 or syswow64 for firebird client versions and look if you have not some conflict with Interbase installed with Delphi Regards,Karol Bieniaszewski Oryginalna wiadomość Od: "craig_...@coxcolvin.com [firebird-support]" Data:

[firebird-support] FB tracker formatting

Hi, Did you know if there is some formating which can be included in report submited to Firebird bug tracker? Some bb-code or something like that? Pozdrawiam,Karol Bieniaszewski

Re: [firebird-support] Re: Set custom value on connection system info

in persistent table a volatile information (if it was possible). The link between a connection id and user id isn't a persistent information (like connections,transaction ecc...) 2018-02-08 6:19 GMT+01:00 liviuslivius liviusliv...@poczta.onet.pl [firebird-support] <firebird-support@yahoogroups.

Re: [firebird-support] Query problem

Hi, Yes,  but source of one column is ommitedVAREFRVSTR_DETAIL.LAENGDE_NAVNYou group by VAREFRVSTR.LAENGDE_NAVN Change your group by or change source of column in subquery Regards,Karol Bieniaszewski Oryginalna wiadomość Od: "michael.vilhelm...@microcom.dk [firebird-support]"

Re: [firebird-support] Query problem

Hi, Your bolded subquery need to have value e.g. VAREPLU_ID but you not group by this field and server do not know its value then Regards,Karol Bieniaszewski Oryginalna wiadomość Od: "michael.vilhelm...@microcom.dk [firebird-support]" Data:

Re: [firebird-support] Re: Set custom value on connection system info

Hi, what do you mean by maintain here? Do you have custom user information table or not? If not then what do you need to store in this context var? I supposed that you have custom user information table and you need to match your user record with server user to know who is logged into the

Re: [firebird-support] Re: Set custom value on connection system info

ivius' liviusliv...@poczta.onet.pl [firebird-support] <firebird-support@yahoogroups.com>:   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

Re: [firebird-support] Re: Set custom value on connection system info

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,

Re: [firebird-support] Re: Set custom value on connection system info

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

Re: [firebird-support] SELECT GROUP BY

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,

Re: [firebird-support] Gradual decrease in select performance - Indexes

Hi, 1. Show us stats from gstat -h from working system i do not belrve that you have 3 transactions working whole the time. I suppose here that you have transaction management problem - i guess2. Consider bigger page size but i do not know how your insert/update scenario looks like and if this

Re: [firebird-support] Alternative to MySQL ELT() function ?

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]

Re: [firebird-support] Moving DB from 32 bits to 64 bits

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:

Re: [firebird-support] Sorting-Problem on recursive query (window functions)

Hi, Please show how exactly resultset should be because i now do not understand your needs. Query return path and return in order a before b what more? Regards,Karol Bieniaszewski Oryginalna wiadomość Od: "josef.gschwendt...@quattro-soft.de [firebird-support]"

Re: [firebird-support] Sorting-Problem on recursive query (window functions)

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

[firebird-support] On update cascade order rule

Hi, What is the order of cascade firing for foreign key. How to gain control to it? Eg. 3 tables 2 reference 13 referece 1 and 2 How can i fire update on table 1 cascade in the correct order to avoid violation of keys? Regards,Karol Bieniaszewski

Re: [firebird-support] MON$REMOTE_ADDRESS

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

Re: [firebird-support] detect if database has changed

Hi, You can also look at sample at http://itstop.pl/pl-pl/porady/Firebird/FAQ1/czas-ostatniej-modyfikacji-tabeli It is in PL lang but triggers are fully descriptive. I prefer generator based approach Regards,Karol Bieniaszewski null

Re: [firebird-support] CTE Recursive left join problem

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

Re: [firebird-support] LIST gives inconsistent results

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

Re: [firebird-support] Firebird performance vs PostgreSQL

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,

Re: Re[2]: [firebird-support] Find duplicate multi-row entries

Please define "set" Regards,Karol Bieniaszewski null

Re: [firebird-support] Find duplicate multi-row entries

Hi, group by + havingis your friend.E.g.Select field1, field2, count(*)From tablexGroup by field1, field2Having count(*)>1 But in your scenario i do not know if this is the solution. Question is if record was changed and in next update "restored" and once again changed is this duplicate or

Re: [firebird-support] Huge performance different from FB 2.5.2 vs FB 3.02

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

Re: [firebird-support] Huge performance different FB 2.5.2 vs FB 3.02

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:

Re: [firebird-support] Huge performance different from FB 2.5.2 vs FB 3.02

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,

Re: AW: [firebird-support] Explicit Login with Windows Domain username

Yes, You must first impersonate user for the current thread and then you can login to fb from that thread Regards,Karol Bieniaszewski Oryginalna wiadomość Od: "'Nikolaus Kern' parzival1...@gmx.at [firebird-support]" Data: 20.09.2017 17:10

Re: [firebird-support] Explicit Login with Windows Domain username

Hi, It is possible but you must change current thread credentials. I do not remember now api call but look in the google for changing credential for the thread Regards,Karol Bieniaszewski null

Re: [firebird-support] Firebird 3 crashes, unable to capture crash dumps ( terminated abnormally (4294967295) )

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

Re: [firebird-support] file size and transactions

>>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

Re: [firebird-support] file size and transactions

> 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

Re: [firebird-support] file size and transactions

No. I only point you how to check this. From your header you can read that oldest active and next transaction have only 5 transactions gap. Other numbers you can progress by running sweep. Regards,Karol Bieniaszewski Oryginalna wiadomość Od: "shg_siste...@yahoo.com.ar

Re: [firebird-support] file size and transactions

Hi, Run Select * from mos$transactions Then you will see if you have long running Regards,Karol Bieniaszewski null

Re: [firebird-support] COUNT DISTINCT issue in Fb 2.5

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:

Re: [firebird-support] Multi-column Foreign key

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:

Re: [firebird-support] Firebird 2.5 rejecting connections

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)

Re: [firebird-support] List of read only stored procedures.

Hi, For point 4 simply start readonly transactionIf it raise exception you got info about reason.Also it is good to start transaction and rollback it if you doesn't need to modify something Regards,Karol Bieniaszewski Wysłano z mojego smartfonu w PLAY Oryginalna wiadomość Od:

Re: [firebird-support] Rename table

Hi, This whole discussion is strange to me.Rename table while are pending inserts to it?How. If statment like rename table exsist then after name has changed all applications must be recompiled to take this new name into account. This looks to me that discussion is not about real problem. Only

Re: [firebird-support] Re: Detecting disk operations

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]

Re: [firebird-support] Re: Detecting disk operations

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

[firebird-support] Detecting disk operations

Hi, Is there a way to detect throught mon$ tables or trace or other way disk operations caused by query? I see only page_reads and page_writes, page_marks, page_fetches but how to distinguish which one:1. Page is read because missed in cache2. Page is read/write beacause of big sort operation3.

Re: [firebird-support] Triggers - One big or more smaller?

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

Odp: [firebird-support] Connection rejected by remote interface

Hi, I saw this error when someone install Interbase over Firebird. But i suppose this is not the case Regards, Karol Bieniaszewski - Reply message - Od: "Aldo Caruso aldo.car...@argencasas.com [firebird-support]" Do:

Re: [firebird-support] Foreign key different field type

>>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

[firebird-support] Odp: Why backlash do not raise parser error

Hi, I see that it is not sql problem only connectivity problem. Delphi Firedac remove it before executing. Regards, Karol Bieniaszewski - Reply message - Od: "liviusliv...@poczta.onet.pl" Do: Temat: Why backlash do not

[firebird-support] Why backlash do not raise parser error

Hi, Why backslash does not raise parser :error? E.g. Select * from rdb$relations\ R Inner join rdb$relation_fields rf on rf.rdb$relation_name = r.rdb$relation_name\ Where 1=1 Try first line only or whole sql. Interesting that mssql also does not raise exception. It have some reserved

<    1   2   3   4   5   6   >