At 20:05 Thursday, 19.02.2004 +0000, Marcel Brink wrote:

>I have a problem when a TIBOStoredProc call a StoredProcedure
>which updates a Record in a Table.
>When I use TIBOStoredProc.ExecProc, I receive NO DMLCacheItem,
>Even though DML Caching is Enabled.
>When I update the Same Record through a TIBOQuery I have no
>problem at all receiving the DMLCacheItem.

That's because DMLCacheItems are generated in TIB_UpdateSQL.SQL_Insert
(IB_Components.pas, line 36776), .SQL_Edit and .SQL_Delete. I guess that
these procedures only get called if you have a dataset on which you call
i.e. Edit and then Post. If you call execute of TIB_Statement then no
DMLCacheItem will be generated.
(At least that's what it looks like to me - please correct me if I'm wrong).
Also I don't know how it would make sense to implement the generation of
DMLCacheItems when executeing a storeproc because then IBO cannot know what
KeyFields and KeyValues will be affected.

HTH,
Markus