>>>What is the syntax to change a field type from DateTime to Date? I receive a cursor from call to SQL Server and want to change the field type to D(date). I tried to use DBSETPROP() but it requires a database so I am trying to see how to use the CURSORSETPROP() but can't seem to find the right syntax.
>>>
>>>Thank you in advance.
>>
>>You can not if you use SPT. BUT you can use CursorAdapter to do this (no need of dataBase).
>
>Thank you all for suggesting to use CursorAdapter. I am not ready to change my app to the CursorAdapter, yet.

Dmitry, there are two places where you must change you code. First Where you use SQLEXEC() to get data and second where you update data. If you only read data, then you must chage your code only in place of SQLEXEC().