>>>>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.
I find that it is so but there are some exceptions. If you, for example, have two columns of the same type (e.g. "C") and you reverse the order of them, no error occurs. But if you change the order of columns in such a way that the types will be in different order, you get error. Now that I know it, I will learn to deal with it.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
