Hi, I just installed Firebird 2.0.1 (from 1.5) on my notebook, but when i connect to the server (local host) i get a -902 "Cannot attach to password database"...
Hi, I have a problem with Firebird 2.01 and the "ORDER BY"-clause: The following Query reports an error "column unknown Person.Name1": SELECT * FROM Person P ...
Winchim (Martin Haide...
office@...
Apr 1, 2007 10:12 am
84978
Hi Martin, ... Stricter syntax. Once you define a table alias, the original table name is obfuscated. This is documented in the Release Notes. HTH, Paul...
... It sounds as if your database file has gotten corrupted. Is this running on a Windows machine? Any chance some other program tried to access the database...
... Well, the one thing that this error is NOT is "typical". It occurs when the engine encounters an error condition it doesn't recognise and/or can't fix...
Hi ! I just read the write-up of Ann Harrison on why FB database can not be shrunk. Want to reconfirm my following understanding on this: 1. Though database...
Hi, What is the maximum number a firebird generator will reach before resetting to zero? I've seen 140372906 but it does not make sense that the generator...
Jacques Marneweck
jmarneweck@...
Apr 2, 2007 9:04 am
84985
... [Non-text portions of this message have been removed]...
Thanks to adam and jft for the subtraction trick (that worked just fine :) ) i found the problem... the sysdba put 'none' to udf access ;) thanks everybody ...
Hi Jacques, ... http://www.firebirdsql.org/manual/generatorguide-basics.html#generatorguide-basics-maxval The max value is a looooot bigger than 140372906, and...
... In a dialect 1 database, its highest positive number is 2,147,483,647 (it is a 32-bit integer in that environment). In a dialect 3 database, the highest...
... the environmental options the >DATE is set to dd/MM/yyyy why does it insert in reverse order the day and the month? ... Cause regional settings doesn't...
... You could also say that dd.mm.yyyy is another one, and yyyymmdd is yet another. :-) Or, yes, you could force the lad to read the manual...;-) ./h...
... that? In ... insert ... Hey, that's why I only mentioned 1 :-) (and the one I can remember, that is). Martijn Tonies Database Workbench - development tool...
... It would not roll over on that number. Check that no-one is using set generator to 0 dml. ... ^ In a Dialect 3 database, and if my math is working tonight,...
Hi! I'm writing a stored procedure, for this table: CREATE TABLE TEMPORALPRUEBA1 ( CLIENTID INTEGER, DATE2 DATE, DATE1 DATE, GENE INTEGER NOT NULL); first I...
SELECT MAX(GENE) FROM TEMPORALPRUEBA1 WHERE CLIENTID = :MINCLIENTID INTO :IDMAX; All references to non-table fields should be preceded by ":" regards ... -- ...
Jorge Andres Brugger
jorge.brugger@...
Apr 2, 2007 4:17 pm
84998
I am working on a large project, with millions of records and over 60GB in database size. Now, I am specificing the hardware required, I have read that FB uses...
... Use a ":" in front of variable/parameter names when used in SQL statements. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL,...
... Firebird was designed when a big machine had a couple of megs of memory, so it has very low memory requirements. For a long time, there was a penalty for...
Hi, I'm running classic server on Debian. When I restore a database ( gbak -c ), the restored file belongs to root. I can connect locally ( isql-fb ), but if I...
Thank you for your response. My doubt is the maximum size of RAM that Firebird can manage, the technical limit. If Firebird limit is 2GB, then, maybe it does...
... I haven't tried, but my guess based on some experience with the code is that there is likely to be a signed long somewhere in th memory allocation code,...
