| Subject | Re: [IBO] BufferSynchroFlags don't work |
|---|---|
| Author | Artur Anjos |
| Post date | 2001-10-20T18:41:28Z |
I'm also using Developer and it's ok. What do you have to check:
a) On your TIBOQuery, check the Keylinks property. I will assume for this example that 'ID' is your keylink. So, put 'ID' on your Keylink property and set KeyLinksAutoDefine to False. Also in TIBOQuery, set the GeneratorLinks property to something like ID=YourGeneratorName.
b) On your 'before insert' trigger, check for Null Value:
CREATE TRIGGER bla bla BEFORE INSERT AS
IF( ID IS NULL)THEN
ID=GEN_ID(YourGeneratorName,1);
...
Note on this trigger: that's not necessary at all for this example. The value ID will never be null, because IBO will take care of that. So, that's a good practice to put this code, because it will only run if you are inserting rows outside your application.
c) On your Quantum Grid, set KeyField to ID. This is need if you will use "Load All Records" on your Quantum Grid.
That's all. I hope it helps.
Artur Anjos
a) On your TIBOQuery, check the Keylinks property. I will assume for this example that 'ID' is your keylink. So, put 'ID' on your Keylink property and set KeyLinksAutoDefine to False. Also in TIBOQuery, set the GeneratorLinks property to something like ID=YourGeneratorName.
b) On your 'before insert' trigger, check for Null Value:
CREATE TRIGGER bla bla BEFORE INSERT AS
IF( ID IS NULL)THEN
ID=GEN_ID(YourGeneratorName,1);
...
Note on this trigger: that's not necessary at all for this example. The value ID will never be null, because IBO will take care of that. So, that's a good practice to put this code, because it will only run if you are inserting rows outside your application.
c) On your Quantum Grid, set KeyField to ID. This is need if you will use "Load All Records" on your Quantum Grid.
That's all. I hope it helps.
Artur Anjos
----- Original Message -----
From: Radovan Antloga
To: IBObjects@yahoogroups.com
Sent: Saturday, October 20, 2001 7:19 PM
Subject: Re: [IBO] BufferSynchroFlags don't work
How are you doing the insert?
I use this arrangement for all my tables and it works.
Are you calling 'Insert' or using the 'Add Record' button?
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
I have DbGrid, DbNavigator for test but in my applications I use DeveloperExpress
QuantumGrid. It is no difference if I insert with Ins key or append after last
record with arrow down or press "Add Record" button in DbNavigator.
Regards
Rado
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]