>>>Suppose you have a SQLPT view that includes a datetime field from a SQL Server table. Suppose also that you want the field in the view to be of type Date, not datetime. Can it be done?
>>>
>>
>>You can use ALTER TABLE command if there're no fields in the cursor with name longer than 10 charcters.
ALTER TABLE mySPTcursor ALTER COLUMN mydatetime D
>
>Sergey,
>
>Thanks for what sounds like a wonderful idea. Unfortunately it causes error 1525, "Function is not supported on remote tables", even though I am trying to change the view, not the table. Anything I missed?
Unfortunately, ALTER TABLE doesn't work with SPT cursor. Sorry for confusion.
--sb--