Thanks for the responses,

My problem is that let's say I have 100 fields and only one field is datetime which I want to convert to date when I create my local foxpro cursor.

If I didn't have that field I wouldn't have to define any fields I would let foxpro do it automatically using the cursoradapter, but now b/c of only 1 field I have to write 100 fields in the the 'cursorschema' and 'Selectcmd '? or maybe I'm missing something?

Thanks.