>Hi,
>
>I know I can use the cursor adapter to transform a datetime from sqlserver to a date in foxpro and handle the nulls when it creates a cursor.
>
>If I do this do I have to define the other x fields (could be 100!!) also? Is there a way to say, "grab everything but the datetime field" and then just define the datetime field to be a date?

Hi Roy,
Venelina is right:
"You can just change the data type in CursorSchema to be D instead of T. You can even create one underlying CA class, program it to make such conversion at run time and use it at every place where you need such conversion."

But You need:

thisform.DataEnvironment.your_cursor_adapter.CursorFill(.t.)

HTH