Hello Jason,

> I think something more graceful should happen.
> I wonder if you would please be willing to make a little sample app for this
> issue?

Sent an email to jason@.... Thanks for investigating.

Regards,
Thomas

> Thanks,
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
> Of Thomas Steinmaurer
> Sent: 17 January 2012 12:34 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] DML Caching Problem
>
> Hello Jason,
>
> I encounter a problem (or possibly this is as designed) with the DML
> Caching functionality.
>
> I have one TIB_Transaction (tiCommitted, AutoCommit=True). Two TIB_Query
> pointing to this transaction object, both using the same query and
> RequestLive is set to True. Both query objects have all DMLCacheFlags
> set to True so both will send and can receive notifications.
>
> Steps to reproduce:
>
> - Go into insert mode with query 1
> - Go into insert mode with query 2
> - Enter data for query 2 and post
> - Enter data for query 1 and post. At this point, I get a "Dataset is
> currently open" exception with the following stack trace:
>
>
> ----------------------------------------------------------------------------
> -----------------------
> |Address |Module |Unit |Class
> |Procedure/Method |Line |
> ----------------------------------------------------------------------------
> -----------------------
> |*Exception Thread: ID=2816; Priority=0; Class=; [Main]
> |
> |---------------------------------------------------------------------------
> ----------------------|
> |005C1BC5|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |SysExecute |26720[2] |
> |005C0F5D|DML_Caching.exe|IB_Components.pas|TIB_Dataset |SysOpen
> |26445[34] |
> |005C0DCC|DML_Caching.exe|IB_Components.pas|TIB_Dataset |SysOpen
> |26411[0] |
> |005C1948|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |SysRefresh |26672[147]|
> |005C0A0B|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |RefreshAll |26288[12] |
> |005C09B4|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |RefreshAll |26276[0] |
> |005C09AC|DML_Caching.exe|IB_Components.pas|TIB_Dataset |Refresh
> |26272[1] |
> |005C98E0|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |SysStateChanged |30257[15] |
> |005C9878|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |SysStateChanged |30242[0] |
> |005C9806|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |EnableControls |30225[7] |
> |005C97CC|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |EnableControls |30218[0] |
> |005C1AEA|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |SysRefresh |26703[178]|
> |005C0A0B|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |RefreshAll |26288[12] |
> |005C09B4|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |RefreshAll |26276[0] |
> |005C09AC|DML_Caching.exe|IB_Components.pas|TIB_Dataset |Refresh
> |26272[1] |
> |005C98E0|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |SysStateChanged |30257[15] |
> |005C9878|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |SysStateChanged |30242[0] |
> |005C9806|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |EnableControls |30225[7] |
> |005C97CC|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |EnableControls |30218[0] |
> |005C82DE|DML_Caching.exe|IB_Components.pas|TIB_Dataset |SysPost
> |29484[62] |
> |005C8010|DML_Caching.exe|IB_Components.pas|TIB_Dataset |SysPost
> |29422[0] |
> |005CDB99|DML_Caching.exe|IB_Components.pas|TIB_BDataset |SysPost
> |31988[4] |
> |005BCF49|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |CheckBrowseMode |24804[9] |
> |005BCEE4|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |CheckBrowseMode |24795[0] |
> |005C8FB3|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |SysBeforeScroll |29936[6] |
> |005C8F78|DML_Caching.exe|IB_Components.pas|TIB_Dataset
> |SysBeforeScroll |29930[0] |
> |005D0580|DML_Caching.exe|IB_Components.pas|TIB_BDataset
> |SysBeforeScroll |33174[1] |
> |005D3346|DML_Caching.exe|IB_Components.pas|TIB_BDataset
> |SetRowNum |34440[10] |
> |00629262|DML_Caching.exe|IB_Grid.pas |TIB_CustomGrid |Scroll
> |4380[37] |
> |0062C5B9|DML_Caching.exe|IB_Grid.pas |TIB_CustomGrid |KeyDown
> |5760[286] |
> |006257AB|DML_Caching.exe|IB_Grid.pas |TIB_GridInplaceEdit|KeyDown
> |2467[38] |
> |0062F66C|DML_Caching.exe|IB_Grid.pas |TIB_CustomGrid
> |DefaultHandler |7367[1] |
> |7707813E|ntdll.dll | |
> |RtlUnlockHeap | |
> |77062210|ntdll.dll | |
> |RtlLeaveCriticalSection| |
> |006253B6|DML_Caching.exe|IB_Grid.pas |TIB_GridInplaceEdit|WndProc
> |2370[25] |
> |75007DF5|USER32.dll | |
> |DispatchMessageW | |
> |75007DEB|USER32.dll | |
> |DispatchMessageW | |
> |0063D081|DML_Caching.exe|DML_Caching.dpr | |
> |14[4] |
> |74C23675|kernel32.dll | |
> |BaseThreadInitThunk | |
> ----------------------------------------------------------------------------
> -----------------------
>
>
> Any ideas?
>
>
>
> Thanks,
> Thomas
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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 ! Yahoo! Groups Links
>
>
>