Thanks Helen, but my problem is that while the event "ReceivedItem" is fired for the table with the same keylinks, it's not fired in the table that is a...
... Marco, I can't tell where you are with this setup. Are you using the DMLCacheFlags settings on the datasets? TIB_DMLCacheFlags = ( dcfAnnounceEdit, ...
Shame on me :(( My "base table editing form" had a transaction component that, I don't know why, had a tiConcurrency isolation level :( I've changed it to...
Hi Marco, ... my small test application based on your initial post works also with TIB_Transaction.AutoCommit = True, so I guess an explicit commit isn't...
Are the two dataset linked with two different transaction components? My "test app" that I've build to isolate the problem, does not work on post, only with...
... Yes. The changeable dataset uses a TIB_Transaction with AutoCommit:=True and IsolationLevel:=tiConcurrency The recipient dataset uses a TIB_Transaction...
You are absolutely right, my changeable were set with autocommit to false. Maybe while experimentig I've changed that :( It's time I sleep for a long, long...
A customer of my has observed a strange behavior, and I have reproduced it. I have a TIBOTable. It's key field (CUSTID) is, of course, a required field. I...
I've a query like: select a, b, c from myselectproc(:myparm) the UpdateSQL is like: execute procedure myspupdate( :myparam, :a, :b, :c) if I assign the...
If cust_id is a decimal (18,2) , you might have run into simular difficulties I expenrienced with TIBOTable. Jason will include my fix or modified fix in next...
No, not a typo :) Here I wrote a sample, just to make clear the situation. In the real query field names are taken with a copy&paste, and double checked, and...
... Oh yes, of course! You are hoping that it will automatically use the same argument because the parameter names match? I'm sure that the binding works on...
Helen, what do you think for IBO, if not Row.ByName() column match is found, try with Params[]? Will it be a easy and positive improvement, or you can see some...
... Keys ... Hi Helen, Sorry, my mistake. Yes, it actually is an insert. The user enters an ID number, which is the key field, then enters the values for all...
... Add an internal field to be used as the primary key and use a generator for it. The user should never see this internal field. What you want to do is...
... I wouldn't allow it at all, of course...I would have a use-inaccessible generated key which gets written into the Insert buffer via GeneratorLinks, or on...
... GeneratorLinks, ... content ... My mistake again. I didn't mention that my ID number key field is just part of the composite key of my table (along w/...
... Why need starts transaction always before prepare? The instructions sequence below is wrong? with IB_Cursor do begin //*** here ib_transaction.started is...
... Fabio> Why need starts transaction always before prepare? The Fabio> instructions sequence below is wrong? Because *anything* you can do with a Firebird...
Like most things, a prepare can only happen within a transaction. Jason knows that this is necessary, and has made it so that the prepare starts the...
... through ... way ... Of course, but this transaction is the physical transaction that exists and is active. The prepare method has opened this transaction....
Hi, Is there any way I can access (read and write) the SQL plan for the TIBOQuery? The optimizer comes up with some horrible one and if I do not change it I...
... When you change the query for the grid by changing the order for sorting, first prepare it and then use the IB_Query.SQLPlan property to provide your own....
... sorting, first ... your own. (I ... SQLPlan is available in IB_Query but not in IBOQuery I am using. I have to use IBOQuery as it is a TDataset descendant...
I apologize for leaving off my specs: This is using IBO 4.2.I, Firebird 1.0. I had moved from TTables to TIBOTables, initially. These are created at design...
... (I think Firebird's optimiser has been improved significantly, but that won't help you unless you switch.) IBOQuery has the property Plan, instead of...
... Alternatively: You should also try to _remove_ the index that is used for sorting (if this does not also remove indexes used in the WHERE clause. Even...
... OK, but we can't guess it for you, either. :-( Some troubleshooting suggestions: 1. Trying to mix TDataset-compatible (TIBO) and native IBO (TIB_) ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
