>>>>>>>>Hi All,
>>>>>>>>
>>>>>>>>I want to change type or display format any field of cursor opened with sqlexec command. I want to do after open cursor. Is that possible?
>>>>>>>
>>>>>>>Sure, nothing impossible :-)
>>>>>>>but what type of field, how do you want to display it, where you want to display it?
>>>>>>
>>>>>>I want to convert datetime fields to date. I can do that with cursoradapter and remote views but cannot do with sqlexec.
>>>>>
>>>>>You can't do that with SPT, but you have two choices:
>>>>>1. Create your own TextBox class which will show that datetime field as date (only date portion of it).
>>>>
>>>>First one sounds me a better solution. Thank you...
>>>>
>>>
>>>Metin, you risk losing a lot of time.
>>>
>>>VFP cannot do this with some ControlSource,Format setting and user readwrite interaction.
>>
>>Sorry, I couldn't understand.
>
>Check this:
>http://www.foxite.com/archives/formatting-textbox-as-date-by-datetime-0000097962.htm

try with a nullable field !