>>>I get an error when calling CursorFill() that goes like this "Base table fields have been changed and no longer match the view fields. View field properties cannot be set".
>>>
>>>I have specified a small set of fields in the UpdateabeFieldList, CursorSchema, and UpdateNameList. The code calling CursorFill() is as following:
>>>
>>>
>>>oCA.CursorFill(.T.,.f.,0, nCommand)
>>>
>>>
>>>Where should I look for solution to this problem? TIA
>>
>>Your CursorSchema is different with the actual SELECTCMD list.
>>Keep in mind that Field in CS should be in the same order as they are in SELECTCMD.
>
>Boris, just for testing I changed the order of columns in my SelectCmd from the order in CursorSchema and the CursorFill() does not complain (no error). Are you sure that the order in CursorSchema and in SelectCmd must be the same?
Yes, if you're using Schema.
If it's not broken, fix it until it is.
My Blog