>>>sequence the records. It works fine if I am using non-buffered view and
>>>tables. But when I use view with table buffering, VFP stops me by saying
>>>view with buffering cannot be indexed.
>>
>>In all the situations where the cursor or whatever didn't like indexing,
>>it came to it that it didn't like having a structural index, but other
>>indexes were fine. So:
>>
>>select myview
>>dx_lc=sys(3) && or dx_lc=TempDir_gc+sys(3)
>>Index on whatever tag first of (dx_lc)
>>Index on anything tag second of (dx_lc)
>>Index on another tag third of (dx_lc)
>>
>>This should work (I've never had a situation like yours, so I can't try
>>it). Now I'm not sure the (dx_lc+".cdx") will be automatically deleted
>>when you close the view - better check on that.
>
>I am getting really frustrated. On one form, my view in table buffering is working fine while on the other it is giving me errors like 'command can't be issue...' and 'view require either DB_BUFOPT...'. I guess I have to stay sane and find out thte problem myself unless you guys have seen such problems before Any chance?.


Is your second form set to a private datasession? If so, you may have to reset the buffering options and multilocks settings. Private data sessions reset some SET commands to defaults that are NOT the defaults you may have set up when you started your program.