i have a BeforeInsert trigger with this lines in it... G = 'CREATE GENERATOR "SAL_' || NEW.MOS_ID || '"'; EXECUTE STATEMENT G ; when i insert a new record and...
... You should remove this processing altogether from the trigger. Using EXECUTE STATEMENT to create metadata is unsafe even in stored procedures but, in a...
Hi I use TIBOTable in Delphi 5 with Firebird 1.5, sometimes with automatic fields definition and most of the time with permanent fields (best of all would have...
Jason, You are right. I rebuilt the dll in D7 and it came out at 11800 Kb, more like what one would expect. There were a bunch of new .dcu files appeared in...
Thanks for your help on this, Hans. I revamped my query along the lines you suggested and it is indeed faster. My big problem, however, turned out to be just a...
... I have no idea what you mean by this! :-) ... I think it would be *possible* to do this, by querying the table rdb$user_privileges at application startup...
... It happens when the user tries to access another record in the dataset while a pending inserted or updated row in the control has no values in its unique...
CREATE TABLE dep ( id_dep INTEGER NOT NULL, name VARCHAR(50) NOT NULL, CONSTRAINT dep_pk PRIMARY KEY (id_dep) ); COMMIT; CREATE TABLE person ( id_person...
Found no problem and I'll email you my little test. Test1: MasterDetail link via a Generator Test2: MasterDetail link a 50 char field. I prefer to use the...
Hi I have several timers running which refresh grids after calling stored procedures to update tables to show current stock status etc. If stock is low a...
Hi When closing ClientDataSets and Applying updates, sometimes the client freeze. When tracing, it seems that IBO indeed does close the query as it should, but...
Does anybody have practical general experience with using Datasnap and IBO in conjunction? Is this a good combination that works great? Or should I choose...
... In Interbase/Firebird the field name max length is 32 chars how did you manage to get a 50 char field??? ... If I'm correct there is no way to change the...
... On second thought you can use masterparamlinks to link using your own parameter and change the query to use a parameter. Calin. Medisys Australia Pty Ltd ...
IBO is not as fine tuned with the MIDAS/DataSnap stuff as IBX is. It is merely due to the fact that I don't personally use DataSnap and have a harder time...
I have not seen this. The CursorGrid is a pretty thin wrapper on top of the TStringGrid it descends from. I suspect it wouldn't be hard to root out the problem...
... did you use my test case? (click on "Run" then click on "Open detail") ... I know about masterparamlinks but that doesn't help. With master links when you...
... Yes, with IBO you need to regard it as a problem if you have column identifiers longer than 24 characters. Firebird identifiers simply can not exceed 31...
... No, that was just a typo in my first post....it's definitely a TIB_CursorGrid. I'll just use the TIB_Query & TIB_Grid for now, which works fine. Thanks, ...
Hello, I'm trying to the following scenario to work, but I'm finding that the second transaction magically causes the first transaction to rollback! Scenario: ...
... thanks for your reply I only mean that on a TIBODataset when I don't define any field, fields are automatically defined on opening, but when I define ...
... Hmm, the first question I have to ask is why you think you have to lock the lookup record? (After that, there would be more questions and some comments!!)...
... Why? Why doesn't ibo names the parameters (the ones that it automatically generates) param1, param2, ... Doing so there would be no problem. ... No. I...
Context is allocating sales against a stock-sheet. The lookup is the stock-sheet number that contains count information regarding a product. eg Stock sheet...
... simple ... replication ... I agree and have had a glance to replication tools : ibphoenix ibreplicator have too high fees and I am studying 2Plus...
... OK, I think the first thing you have to let go is your belief that a lookup is the way to implement this 1:1 relationship. "Lookup" is really a ...
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.
