Subject | Re: [IBO] TIBOStoredProc and DML |
---|---|
Author | jwharton@ibobjects.com |
Post date | 2004-02-24T20:01:56Z |
That appears correct.
Thanks,
Jason Wharton
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
At 20:05 Thursday, 19.02.2004 +0000, Marcel Brink wrote:
(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
Thanks,
Jason Wharton
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
At 20:05 Thursday, 19.02.2004 +0000, Marcel Brink wrote:
>I have a problem when a TIBOStoredProc call a StoredProcedureThat's because DMLCacheItems are generated in TIB_UpdateSQL.SQL_Insert
>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.
(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