>>>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.
>
>My SelectCmd is "select * " (that is all). Are you saying that I can't use "Select * but need to list the fields one by one?
Yes,
And this is better than [*].
If you have many fields in your SQL table you could script the SELECT in SSMS and copy and paste it in CA.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.