Hi,Groups! I use Ibobject and firebird 1.03.972 on win2k server. I have a application write by delphi, when a record before post,I need a lotno,so I write : ...
Hi, ... But, the original question was if it is possible to use events in this manner: POST_EVENT 'event name' new.field_name THAT is not possible. Sending...
... No, you have to have registered interest in the event. That is true. Wild-card registering events was on the wishlist someday though. With regards, Martijn...
... Given that your calculation causes the generated number, at its current order, to shed the first digit, you would start getting duplicates if you spun more...
I have a need to limit the number of connections to both IB5.x and FB databases. I don't necessarily have control of the application that is accessing the...
... I think if you are unix/linux and CS you could limit the number of connection in (x)inet.d. But I am not sure... Give it a try and report back if it...
... restricted to ... Thanks for your answer. I didn't mean to post data with the event but to post an event named after the data contained in a field. If for...
Just for the record - when you install firebird 1.5.2 on a windoze box (yuck) - there is a little problem - it installs fine, but does not leave any obvious...
Hi Helen, I thought there was also a transaction issue as well. I was getting duplicates as well at one point using a TIB_Cursor and you recommended the ...
... The Win32 install does nothing to change the password for sysdba. If the security database is non-existent it will provide a default empty one with just...
Paul Reeves
paul@...
Apr 1, 2005 4:09 pm
58243
The actual problem was encountered by a friend who asked for my help around this - he swears (in Latin or ...) that he tried this (I asked). Turns out he did...
... filesystem. ... gbaking ... of ... deny ... in ... believe ... bringing ... answered ... on ... whether ... or ... Why you shutdown the server to backup...
... Additionally, v2.0 includes a new backup tool (currently named NBackup) which will allow you to: - take a direct OS copy of a live/online database - make...
I have installed firebird database on a multicpu machine with win2k server or window 2003 server. In either case, the performance is much slower than the...
... This doesn't look like my code! maybe a mod of someone else's, though. This routine could certainly return duplicates - it would only take the increment...
... That would be expected, unless CPU affinity were pinned to one cpu. (Superserver must be pinned to one cpu). ... So far, there is insufficient information...
... if you ... I understand,But I can sure my client won't key over 2000 records within 1 month. so I used this structure lotno. If you ... duplicates ... I...
Hi I' ve had the same problems on server with 2 processors and W2K, there was HT also, and I think that this is the cause of problems. I've had to switch to...
... <glenndetollenaere@y...> wrote: I have a similar problem with an 2000 server and XP Clients. One XP Client is performing fine. The others are slow or more...
... How long does it take? Inserting 20000 records is probably of the order of 5 secs or less - maybe not easy to time correctly. Also, TaskManager may not...
Hi all What kind of a SQL statement can we execute on a database to retrieve all details (fields, indices, constraints, triggers, etc.) of the given table...
... One statement? No. Write a parameterised stored procedure that queries the relevant system tables, targeting rdb$relation_name = 'aTable'. ... Use isql...
I am using the firebird .net provider and am getting a timeout message during a long transaction. In MSDE I can set the command timeout to 0 to tell it to wait...
I'm sure that someone mentioned a document about upgrading interbase 6.5 to 7 does anyone have the URL please? -- Nick ... Founder & Listowner of the Prolifics...