Query not reflecting table changes

[JHenshawJr]

I have a query & Grid form and then button to a new form where record is inserted. After return, no matter what I do: refresh, requery again, reopen transaction, etc... The query grid will not show the new record, though I see it fine in the IBCONSOLE data. Is there something I'm not doing here??

I am using Borland C++ Builder 6.0 and the demo download of CoreLabs Interbase components.

Thanks for any assistance or ideas.

Joe

[Alex]

I suppose that this issue is caused by transaction isolation level, in InterBase and IBDAC by default it is Snapshot. The solution is to use transaction with "Read Committed" isolation level.
You can do this by accessing IBCConnection.DefaultTransaction.Params property in Object Inspector and setting "Read Committed" Transaction Kind.

If the problem persists please send us complete sample to demonstrate it and include script to create server objects .

[JHenshawJr]

Thanks for the great support! That worked, now after return and requery
everything is displaying correctly. Thanks again! Joe