>I retrieve a cursor from SQL Server database using SQLEXEC. One of the fields in the table is smalldatetime. I would like to convert it to Date type so that my UI does not show the time portion. I tried to use DbSetProp() function but it requires a database.
>Is there a way to convert this column on-the-fly while retrieving from SQL Server?
No.
> Or should I use ALTER TABLE to change the column type?
It'll not work if cursor has fields with long names.
--sb--