Jim,
I got the cursors open fine now. After setting cursor properties of order, filter, buffermodeoveride=5, table data looks in proper order with proper filter on, but the tablereverts do not work. The error is: buffering is required for this function to work, roughly. In the init event of the form that my custom object is on, I have set thisform.datasessionid=nsession, where nsession=thisform.cstbv1.osession.datasessionid.
Any ideas on this? I worked around the problem by using a cursor as recordsource for my grid, but I will need buffering somewhere.
>>Thank all for replies to this. Something interesting I've just noticed after getting this working:
>>
>>When I create a session object and reference from it the DE and then addobject 8 cursors with 11 megabytes involved, the time to instantiate everything and open the cursors is about .3 seconds. If I do the same thing but addobject the session object to a custom object, the time for everything to occur is only .004 seconds. The data is really there also as I can access any of the tables!! That was quite a surprise. Any ideas on this?
>
>Terry,
>
>Are you measuring the same time interval for both of them? It is possible that the DE time includes the instantiation of the form, the DE, and the Session object.
>
>Anyway with a difference of .296 seconds, I would go with the best logical design and forget about the time. It is not like you create these things 1,000,000 times in a loop.