Subject | Re: [IBO] DML Caching Again |
---|---|
Author | Markus Ostenried |
Post date | 2001-03-18T23:42:52Z |
Tony,
and from there post an event that a change has occured.
If you have done this, what are your DMLCache triggers in table A ?
Do you use a TIB_Synccursor ?
It won't notify you of changes if your TIB_StoredProc's connection has the
same USER name as the TIB_Query's connection. You'd have to use my
creation, the "TIB_SyncEvents" for this :-)) it's pretty much the same as
the SyncCursor except it doesn't check the USER name of the DMLCache
record.
Just some ideas,
HTH,
Markus
> DML Caching works with TIB_StoredProc??.yes, it should work.
>I have a Stored Procedure wich insert a record in a table A takenYou can get this working by creating a DMLCache table in the database
>from another table B.
>All works fine, but to see the newly added record in Table A i MUST
>refresh.
>I have attempted all the DML Caching feature in various mode, but it
>don't work for me.
>Any hints?
and from there post an event that a change has occured.
If you have done this, what are your DMLCache triggers in table A ?
Do you use a TIB_Synccursor ?
It won't notify you of changes if your TIB_StoredProc's connection has the
same USER name as the TIB_Query's connection. You'd have to use my
creation, the "TIB_SyncEvents" for this :-)) it's pretty much the same as
the SyncCursor except it doesn't check the USER name of the DMLCache
record.
Just some ideas,
HTH,
Markus