Hi, I found strange issue with UIB2 delphi components and Firebird 1.5 classic under Windows. Sweeping database using service API (with this component)...
Hi, Assume I have 2 branch offices. One at Northpole and the other at Southpole (brrbb). Each of them has a same customer table with fields like this: ...
... Hello, An usual solution to your problem might be that one table PK starts at 1 and the other at 1.000.000.000 or whatever number is comfortable to you. ...
... at 1 ... Ok, adding dept_id field to the table: customers ... cust_id VARCHAR(20)(PK) cust_name VARCHAR(80) dept_id INTEGER and then modify the trigger to:...
I have the following domain: dom_input_code CHAR(1) CHECK (VALUE IN ('C', 'D')) I have a table with the input_code column that uses the domain as the data...
... better still... generators for PKs increment by 10 or 100 (being the number of server stations you might one day have - maybe 10,000 stations! - so...
... You are right,I forgot about this solution. We usually use these two I wrote before since is faster and more visible (at least in the business logic we...
Hi Eyal, ... This behaviour is there from the beginning. I don't know if this is compliant to the SQL standard, but the following works: dom_input_code CHAR(1)...
Hi All: It seems I've established a connection to the EMPLOYEE.FDB from within my Liberty Basic program as I'm getting what appears to be a valid handle - YAY....
Helen - The only reason is that I used it some years ago to maintain/backup MCI's Interbase DB's for their 800 number lookups on remote servers...just a...
"select * from RDB$database" is nice and simple and will always return 1 row -- Nick ... UNIX, C, Panther, Ingres, Interbase, Firebird - Available Shortly ... ...
Hi all, Anyone know a way to get the change count on a table? I'm referring to the number of times the metadata has been changed which can be 0 - 255. Thanks!...
Um, try: CONNECT localhost:D:\APPS\Firebird\examples\employee.fdb; ... -- The information transmitted herewith is sensitive information intended only for use...
... Sure it is! Make your primary key compound: one part created with a generator, the second part being either N (for North Pole customers) or S (for south...
... NULL is not either 'C' or 'D'. The behavior you describe is correct and follows the standard. You'd see the same behavior if you put the constraint on...
Sorry, I hit enter without changing the subject line of the prior e-mail to something else. Sorry, I didn't change the subject on the last post before I hit...
I am trying to build a resultset from a list of ID Values. I would like to do this in a stored procedure rather than in Delphi code because there are lots of...
i have installed firebird 2.0 on my windows server 2003. I tried gsec - user sysdba -password masterkey. I wanted change sysdba password and i already have...
From: "francoemic" <Michel.Francoeur@...> ... Firebird 2.0 questions/problems belong on the development list until it is released as a final product. The...
... So you are telling me that if I demand your value can only be either 'C' or 'D' that I am meant to accept your NULL? What a strange concept! You give me an...
... Well if that works then he is not using the embedded engine. He would be using whatever full server is listening to 3050 on the local machine. If you pass...
... if you're doing this all the time from your apps, then I would suggest you let the db do it with a where clause. Add another field(s) to allow these lists....
... For small datasets, this will work, but be aware of the limits of the SQL parser. In particular Maximum Query size: 64K Maximum members in an IN condition:...
... Actually, it seems our behaviour complies with an old standard but not the current one. According to Paul Ruizendaal (I think it was he who raised it in...
... Pass a string as a varchar of sufficient length and write a procedure that's called within your procedure to parse out the individual values successively...
... Hah, Woody, the beleagurered list mods need all the help they can get! However, to Michel: if you are playing around with Fb 2.0, it is ESSENTIAL to study...
Hi, Can someone point me to some documentation explaining concisely the concerns some people have with using the BDE to access a firebird database. The reason...
Please don't response to the this thread, which had been solved two weeks ago and I am now using full API for both stand-alone and remote server with dynamic...
