>How do you make a field/column retrieved from SQL server where it is type SmallDateTime to just Date in VFP? The cursor is retrieved using SPT.
>
>I tried the following:
>
>

>DBSetProp("v_invoice.invoice_date","Field","DataType","D")
>

>
>But it has not effect.
>
>TIA.

Seems to work fine to me.
Did you just Requery() the view, or did you close it and USE it again? I find myself doing that sometimes.