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.
Charlie