>>>>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.
Thank you, Boris. This complicates things a little for me and I am thinking that maybe I should go back to NOT use CursorSchema but simply get ALL fields via CA. And then deal with DateTime type in the UI layer.
"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