... I'm sure I don't understand the question properly, because a Firebid UNIQUE constraint on a null-able column doesn't take NULLs into account, as long as it...
... Oh!? I didn't know. RTFM then... :-) I was working in SQL Server and then this cropped up. It didn't cross my mind that it could be different... SQL Server...
117787
Mark Rotteveel
mark@...
Apr 24, 2012 8:31 am
... Even it is compound, the NULLs are not taken into account for uniqueness, only the non-null parts: http://www.firebirdsql.org/manual/nullguide-keys.html --...
... Yeah, welcome in the world writing applications supporting multiple backends. Little, neat differences along different products. ;-) Regards, Thomas...
... Been doing that since about 1997 actually. Don't know why it didn't occur to me this time. But it wasn't an app - just some ad hoc data work - import data...
117792
Mark Rotteveel
mark@...
Apr 24, 2012 8:52 am
... I think we misunderstood each other. My comment was on the fact that you claim - or at least so it seemed to me - that NULLs in unique keys only work for...
... Correct and I hope I didn't claim that. ;-) SQL Server is different when it comes to handling NULLs in unique constraints. Oracle and Firebird behave the...
Hi, from the docs I have read I should be able to alter an SP, even though another process is running it (using firebird 2.1 I know this was an issue in 2.0) ...
... Interesting. That's one for the "Learn something new every day" department! It does tend to imply that SQL Server is treating NULL (a lack of a value) as a...
... Yes. Sort of, I don't know the MSSQL internals. Google offers a lot of discussions on that SQL-standard compliant-breaking behaviour in SQL Server. ... -- ...
117797
jegaza@...
Apr 24, 2012 10:52 am
... You can do it in superserver, classic/superclassic blocks metadata changes while there is one connection using it. Jesus [Non-text portions of this message...
Nick Upson ... Thanks, I hadn't considered it might vary by classic/SS, any idea how I can identify the blocking connection? (is this case there should be...
117799
jegaza@...
Apr 24, 2012 11:01 am
... Try select MON$ATTACHMENT_ID from mon$statements where mon$sql_text containing ... Jesus [Non-text portions of this message have been removed]...
... I would only expect that to work if the SP was called directly by a process, if SP_a is the one called which then calls SP-b (the one I want) it would not...
Has anyone successfully made a working UDF that uses one or more of the calls to firebird (e.g. ib_util_malloc or isc_encode_date ...)? I cannot get the syntax...
I'm trying to use ODBC to get at a Firebird database for the first time. The db is on the other end of a VPN link, but the pings are around 75 ms in the bad...
... The client does fetch the resultset row by row. The Time sould be determined more by the size of result than by the complexity of query. What Version of FB...
During Firebird (2.5.1.26351) silent upgrade, i got this message "Earlier version Firebird installation was detected. Do you close this installation?". How to...
... Ohhhh, yikes! Out of curiosity, is this a holdover from pre-SQL days? And is this fetch behaviour in the ODBC client itself? ... I believe the server is...
... Sorry not being able to reply earlier Mark. So this mean I will have to attach with each database and then check MON$ATTACHMENTS for each one of them....
117807
Matheus Degiovani
matheus@...
Apr 25, 2012 6:32 pm
Hello, ... Is this actually true? I just ran a test, remotely (through an internet link) connecting to a database on a firebird 2.5 server, and I ran a ...
Hello, We have made C# (.NET) application that is using Firebird embedded V2.5.0 We using ADO.NET as interface to the Firebird database. And sometimes at...
... Well, it won't be random. It will occur whenever someone tries to enter data that breaks a CHECK constraint that you have on a domain or a column. ./heLen...
... Hmmm. Can I run a 2.5 server on another port, and access the same database? Since I'm only using SQL for reporting (not updates), would this be a workable...
... Exactly what is the definition of your fields? I would expect (or rather, would be slightly surprised if not - I really don't know anything about...
... I can't figure out an easy way to cut-n-paste, but generally there isn't a single column larger than VARCHAR(100). It's an extremely simple database with...
... One database can only be served by an single instance of FirebirdSQL. I would gess it to be nearly impossible to make different releases of classic server...
I am looking for help with a firebird odbc error. We have Endicia client attempting to post back shipping data to Fishbowl Inventory; SQL Statement: INSERT...
Hallo there, i have a strange problem, i do not know how to solve ist. Description: The Database filesize on disk is about 18 GB. Backup/Restore do NOT lower...
