... One of the parameters passed back and forth between the client and server is a number that identifies the transaction for the current operation. For some...
Hi all, Yestardey I had a big problem with database corruption. Objective: Fedora 3.0 Firebird 2.0 RC2 ForcedWrites = On Page Buffers = 2000 Sweep Intervale =...
... What kind of database corruption? Are there any interesting messages to indicate database corruption? ... They are network errors. 104 often means a user...
... messages ... any ... file ... crashed, ... indicates ... the ... was ... getting ... is ... and ... Hi Helen, I do commit after each entry so it must not...
Could any backup routines interfere with the database? Gbak should be safe, but file copying isn't. I don't know whether antivirus could interfere or not. (You...
Hi I'm looking for the most up-to-date SELECT syntax description for Firebird 1.5. Mainly I'm interested in a detailed join mechanism description, how the ...
Hi, I have one dilemma. One of my clients has an old VB application which uses FB1.0 with an XTG ODBC driver. The VB app is closed source, I can't get the ...
... Rephrasing the question, Is it safe to run FB 1.0? Well there are a lot of known bugs resolved by 1.5 (check the 1.5 release notes), so there are some very...
... The brackets are just for order of operations within a join condition, probably only required when wanting to mix AND + ORs in a particular manner. You...
Robert, ... There's an issue with incorrect handling of null values as pointed by Adam a while ago. IN the same post he offered a workaround, search for a...
I've placed the first book of a Firebird 2.0 manual on-line: http://www.janus-software.com/fbmanual/ This book is about the stored procedure and trigger...
... No, of course not. Though we normally don't use the term 'join order', we talk about PLANs. Firebird may use multiple indexes against any particular table...
... No, we are talking about two different things. You are talking about the PLAN order, or if you like the order the tables are considered when executing the...
Hi Adam, ... Note that this is possible in every FB version: SELECT * FROM a LEFT JOIN (b join c ON (c.id = b.bid)) ON (a.id = b.aid) Regards, Arno Brinkman ...
Hi Aron ... Aron, could you tell me please where this use of the brackets is documented? I mean those between a keyword "join" and "on". Regards Radek...
hi i know it is not connected with the newsgroup theme , but i would be glad for any suggestion : how can i find if there are two groups with the same values ,...
Hi Maurizio! I'd say your question is very much an on-topic subject for this list. Here's my five minute attempt for a solution: select M1.ID, M2.ID from...
... Arno, That is great, it was a weakness that bothered me, but that I would use a view to work around. How does this affect the PLAN. Normally I would expect...
... 1.5.3 specifically does not have a 64 bit build. There were some 1.5ish Windows 64 bit builds at some stage, but they were pulled. I am pretty sure it was...
... http://en.wikipedia.org/wiki/WOW64 Mind you, you would probably want an AMD processor so your code is running native x86 32 bit calls rather than going...
I wrote a fairly complex select statement (mainly the 270 lines with JOIN clauses were complex) trying to flatten a relational structure (for further...
Set, ... Welcome to one of the old-time bugs in Firebird and InterBase. Not reporting the full plan. This can either result in total garbage being returned, a...
... AFAIU, either the binary plan representation or the textual one couldn't fit the passed buffer (depends on a tool, but not more than 64K) and some entries...
