>>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.
I didn't Requery the view since this is not exactly a view but a cursor retrieved from SQL server using SQLEXEC().
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham