>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.

The short answer is "grid reconstruction behavior". The long answer is that SPT is recreating the cursor with every requery. With the grid bound to this cursor, it will lose its controlsource and all definitions when you requery. Try setting the cursorsource to "" before the requery and restoring it afterwards. You may have to redefine columns at that time as well, I'm not certain.

Chris.