I have a parent-child form with two CursorAdapters on it. Let's call it Order and OrderDetail.

Order has BufferModeOverride set to 3 and OrderDetail is set to 5 (table buffering).

OrderDetail.SelectCMD is "SELECT * FROM OrderDetail WHERE OrderID = ?VP_OrderID"

VP_OrderID is a private variable set to Order.ID at runtime before OrderDetail.CursorRefresh() is called. Order.ID is of Integer type.

When I call OrderDetail.CursorRefresh(), it gives me error "Table buffer for alias "OrderDetail" contains uncommitted changes (Error 1545)".

I checked with GETFLDSTATE() and there are no pending changes. If I issue TABLEREVERT() in BeforeCursorRefresh event, it works.

However, if I change BufferModeOverride to 3, error goes away but it stops refreshing the cursor.

Any ideas?