Hi John,

Try saving the current buffer mode of the cursor, then set the buffermode to zero and do the indexing. Then restore the buffer mode. We use this method all the time when dealing with remote views. Here's a sample:

SELECT rv_MyView
lnBufferMode = CURSORGETPROP('Buffering')
INDEX ON MyIndex 
CURSORSETPROP('Buffering',lnBufferMode)

HTH,
Arriyel

>Hi,
>I am trying to develop my vfp app using ntier pattern.
>The design structure is as follow:
>
>DataEntryForm: Private Data Session, Table Buffering
>oBizObj: Default Data Session
>DataAccessObject: Private Data Session, Table Buffering
>PickListForm: Private Data Session, Non-Buffering
>
>DataEntryForm.oBusiness---->oBizObj
>oBizObj.oDataObj---->DataAccessObject
>
>I create my business object in DataEntryForm.Init()
>I have a problem that, if I launch a PickListform from my DataEntryForm and try to INDEX the picklist cursor, VFP return error "Command cannot be issued on a table with cursors in table buffering mode (Error 1579)". I have check the cursor and it is non buffering. It work fine if it launched individually.
>
>After my testing, I found that, if I rem the line to CREATEOBJECT("cBizObj"), then everything will be fine. Any ideas why my cbizobj can effect my PickListForm since they have their own data session?
>
>For your info, Once my BizObj lauched, the only things will be executed are CREATEOJECT("dataaccessobject") and dataaccessobject will USE mytable.
>
>Any ideas?
>
>Thank you