Helen Borrie wrote:

>>Iam sorry for the cross-post. I think I will reply here? since you
>>respond me here. I dont have any before insert trigger.
>>
>>
>
>You don't have any before insert trigger on the suppliercredit table?
>
>
>
>>And I dont have
>>any application code that is causing null to be posted. in the counter
>>table the amount value to posted correctly. Where should I check this
>>problem
>>
>>
>
>In the other list, you amended your original report and said that the after
>trigger did, after all, work with IBExpert. (First, you said it
>didn't). IBO doesn't (can't) change what the server does. So if the
>counter table is getting the correct value and the value isn't null, then
>the problem is occurring somewhere between when the update gets posted and
>when the AfterInsert trigger fires - regardless of whether you do the
>insert with IBExpert, dbWorkbench, your app, or whatever.
>
>Helen
>
>
>
>

Hi Helen, can you please help me with this one. I don't have any idea
where to start... I have tried many time using ibexpert and it work fine
after inserting a record on counter table. Yes Helen I don't have a
before insert trigger in suppliercredit also. In may application code, I
dont have any code on before or after post of the ib_query.

One thing that I think of is ... Iam sorry that I didn't mention this
earlier, I have my counter table setup as a master table in IBO. Could
it be that since the counter is a master table there is a postretaining
that is happen that could affect the trigger?

Thanks a lot

James