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