>>>>>>Hi,
>>>>>>
>>>>>>When creating a cursor adapter I set up the value of property CursorSchema and set property .UseCursorSchema to .T. but see no effect. First I changed the DateTime type to Date type. Then I even set type of all columns to "Z" (some non-existing type) but in either case the cursor is filled with data from SQL Server with no error message and with all types exactly as they are in the SQL Server. What could be causing that the CursorSchema is not recognized?
>>>>>
>>>>>Where did you set these properties?
>>>>
>>>>In code, right before I set the values of .KeyFieldList, .Tables, .UpdateableFieldList, and UpdateNameList.
>>>
>>>In the Init method of CA? Can you set these properties in Property Sheet just to test.
>>
>>No, I am setting the properties of the CA after it is initialized. I will try to do it in Property Sheet.
>
>Try the property sheet or in the Init.
I think I found what I was missing. I was calling CursorFill() with a wrong parameter.
"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
