[firebird-support] any zeos/fb/lazarus users here that can verify transaction behavior

Hi- I am using zeosdbo-7.1.4, fb 2.5 without the extra "d", and lazarus v1.4.2. I have a similar thread posted in lazarus db forum but it looks like it might go unanswered. I will try to keep this short as possible. in isql I can make this work with two isql-fb open: set transaction read

[firebird-support] Re: SELECT for get the number of contexts

26.09.2015 05:59, 'Walter R. Ojeda Valiente' wrote: > > Is there some SELECT that can give me the number of context a stored > procedure has? No, it's impossible. > Other question: > > Which are the comands that count as context? > > I know: INSERT, UPDATE, DELETE, SELECT, UNION. Is there some

Re: [firebird-support] Re: SELECT for get the number of contexts

Thank you very much Dmitry for your answer, it is more clear now, however I still have some doubts. According to Vlad Khorsun, each INSERT, UPDATE or DELETE has 2 contexts, cause of the variables NEW and OLD of the triggers. Is that not true? The only way to know how many contexts a stored

[firebird-support] Firebird 3 compression data

According to this (very good) news, http://www.firebirdnews.org/firebird-3-protocol-benchmark/ Firebird 3 can have compression of data. Excellent!!! However neither in the above page neither in the "Firebird 3.0 Release Notes"

[firebird-support] Queries & reads with CTE

I have a query with a couple of CTEs. Only one CTE queries from the tables. All other CTES query this CTE and then finally joined up. E.g. with MAIN_CTE as ( //Query from tables ), CTE1 as ( // query from MAIN_CTE ), CTE2 as ( // query from MAIN_CTE ) Etc Select * from

[firebird-support] Re: any zeos/fb/lazarus users here that can verify transaction behavior

oops... I got it to work now. this time I put in BOTH: isc_tpb_read AND isc_tpb_write. I had just isc_tpb_write and it didn't work. sorry, jim

Re: [firebird-support] Re: SELECT for get the number of contexts

On Sun, Sep 27, 2015 at 1:37 PM, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > The only way to know how many contexts a stored procedure has is looking > at the source code and counting handly them? > > The limit

Re: [firebird-support] Firebird 3 compression data

Re: [firebird-support] Firebird 3 compression data

Hello Carlos Thank you for your answer. In your article you has written about the benchmark with and without compression. How you did that? You have "FB 3 padrao" and "FB 3 compressao". If I want to compare FB 3 against MySQL, Postegre, or whatever: how I can have compression enabled or

Re: [firebird-support] Re: SELECT for get the number of contexts

Thank you very much Ann, it's very clear now. Greetings. Walter. On Sun, Sep 27, 2015 at 5:23 PM, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > > > > > On Sun, Sep 27, 2015 at 1:37 PM, 'Walter R. Ojeda Valiente' >

[firebird-support] Why during installation firebird.msg is not being copied in c:\windows?

Hallo, I installed FB 2.5.4 like by defaults. When I get an error (i.e. password incorrect) FB returns a Error message like this: "SQL Error: Your user name and password are not defined. Ask your database administrator to set up a Firebird login.. Error Code: -902. can't format message 13:98