I'm having a problem requerying business objects that use SQL Pass-Through (SPT) and that are linked to grids inside cListObjEdit containers.
If I create a business object with the same properties, except that it accesses a remote view stored in the DBC instead of using SPT, I have no problem retrieving data.
The problem surfaces after READ EVENTS, when I move the record pointer. When I requery the business object that uses SPT, the grid becomes blank and disabled. If I do the same with the business object that uses a remote view, I get the correct result.
Having been sold on the benefits of SPT, I am eager to use it instead of remote views.
Much obliged for any advice.
Joseph A. Koontz