>>>>>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...
Sure, I prefer it also :-)
I think I saw such class on Andy and Marcia site, but not sure.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.