Thank you for replying so quickly to my post, but you still haven't answered to my question: will there be support for 2 transaction in ib_query (one for the...
Mihai Chezan
mcq@...
Jul 1, 2004 8:30 am
31669
... to ... forum ... component ... Having now looked at the source for this component (in IBC_DateTimePicker.INT), I can see that it is not fully implemented. ...
... No. One IB_Query cannot be in two transactions. That isn't an IBO limitation: it's a database rule. What FIBPlus does, it starts a NEW transaction when it...
... You'd have to do that in the database, using a trigger, if you actually want to *store* date and time as separate values. If you want a timestamp split...
Thank you for taking the time to answer to my post. My question from the first post was answered. ... That's not what I want. I want the view to reflect DML...
Mihai Chezan
mcq@...
Jul 1, 2004 4:42 pm
31673
It is the same as for TUpdateSQL component. See Delphi help on this. Jason Wharton ... From: Steve Harp [mailto:steve@...] Sent: Wednesday, June...
Use the SQLWhereChanged property. It's job is to let you know prior to opening the query if any search criteria has been applied during the OnPrepareSQL phase....
I'm having a problem with the TIB_UpdateBar component. The glyphs on the buttons are invisible. I am NOT using custom glyphs. Everything was fine before,...
Hello Friends... Would he/she like to know in if anybody possesses some function to shoot an error message to the user in case other user is Editing a certain...
I think the FireBird data base engine it self with an Exception Message in a on a before insert/update/dele trigger on your registration may have your...
I had this problem some years ago. It was a grafic driver problem. Try to turn off / down the hardware acceleration and see what happens. Andreas ... [Non-text...
I can see that my where params on sql update statements only use the key fields. Is it possible to make it use all fields? in order to make it impossible to...
... They only need the key fields. InterBase and Firebird never do field-level updates. ... You misunderstand how an update works. The update will be update...
Hi Vahan, ... I don't know if anyone has made such a listing. But for the differences between InterBase 6.0, Firebird 1.0 and Firebird 1.5 you can consult the...
Hi Helen, ... earlier). ... distributed model? Not distributed but merged. Borland provided a TLocalConnection (had better be named TNoConnection) component to...
Hi, ... I think it would be possible to use 2 separate transactions. But, there might be some limitations/complications and would require some work, to make it...
I'm sorry - I'm still a bit confused. I tried to set the properties on the transaction as you suggested. Isolation = tiCommitted RecVersion = False LockWait =...
... By "Save" do you mean "Post and Commit"? You can never prevent overwriting of others' work once it is committed, if your transaction is newer than the one...
... overwriting ... than the ... partial ... change that. Perhaps confusing is that Jens wrote about getting exceptions from FB/IB when user B changed a record...
... properties on ... instances ... record and ... got no ... the ... IBO ... or I ... it?? ... not ... new ... database ... the ... That was my point exactly!...
Hello, Would he/she like to know how to create Indexes in the database Firebird and with applying this index in a SQL to return the data of a register of...
I'm really interested in this answer. As you can get from the first Helen answer, seemd that there was some sort of "magic" for preventing locks in FB, but I...
... That doesn't really make sense. As I said, it's not a runtime problem, but something that's being compiled into the executable that's different. Once...
... rows ... by ... And how is this taken care in IBO? ... attached ... And how do you see the result in the read-only TIB_Query? Do you call TIB_Query.Refresh...
hello Helen, sorry to be so late in answering to your post. I have made as you suggested, that's to say call TIB_Column.FocusControl before raising the ...
Hi, ... It hasn't been implemented in IBO, and I don't know if Jason will implement it. ... Yes, I do a refresh. If I would have the TIB_Query.FetchWholeRows ...
... I'm a little disappointed for that. ... The problem with refresh is that if a user scrolls the grid from record 1 to record 500 and you then issue a...