Thank you for your message. I don't use the Builder but you gave me a good idea on creating my own "mini" builder, just so that I can convert DateTime to Date.
>I think you have to list them all. The caBuilders out there can do this.
>FYI, we have added two properties to caData (our ca base class) to aid the builder so if I want other fields brought into my cursor, the CursorSchema is set up properly.
>BuilderSchema = "Field1JoinedIn C(10)" && The builder will bring in the fields from the main table.
>BuilderSelect = "OT.Field1JoindIn JOIN OtherTable OT ON .... WHERE T.SomeID = ?This.KeyValue" && The builder will add in the fieldslist and the proper FROM clause.
>
>
>>Hi,
>>
>>Do I have to specify all columns of the CursorAdapter cursor in the CursorSchema property? What I would like to do is only specify in the CursorSchema property column(s) of DateTime type so that they would be converted to Date type in VFP. But all other columns will be listed in the UpdateableFieldList and UpdateNameList. Is this ok?
>>
>>TIA.
"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
