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?