That is why we are using local views for data that needs to be updated. For SPT cursors that are readonly we use a routine that will create a new cursor with the datetimes converted to dates...

Walter,


>When getting a cursor from SQL Server (using SPT), is it possible to automatically convert DATETIME field column to DATE column (of the same name) in VFP cursor?
>
>Thank you.