>Hi all
>
>My app is using MSSQL as DB. I need to create a cursor using SPT.
>
>Is there a way to convert datetime fields in MSSQL as date field in VFP cursor?
>
>Right now I have to do another SELECT with TTOD but this will slow performance as my cursor has some 300,000 records.
>
>I have tried the various CONVERT and CAST but there end up as Char field in VFP cursor.
>
>Is there any way to directly convert datetime fields to date fields with SQL Pass Thru?
>
>Your assistance and advice is really appreciated.
>
>Thanks & Best Regards

No, as I just learnt reading this thread Re: Syntax for cursorsetprop to change field type Thread #1133437 Message #1133449