>>>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).
2. Do something like this:
SQLEXEC(....,"tmpCursor")
lcSelect = "SELECT "
FOR lnFor = 1 TO FCOUNT()
IF TYPE("tmpCursor."+FIELDS(lnFor)) == [T]
lcSelect = lcSelect + "CAST(" + FIELDS(lnFor)+" AS D) AS " + FIELDS(lnFor) + ", "
ELSE
lcSelect = lcSelect + FIELDS(lnFor)+","
ENDIF
NEXT
lcSelect = LEFT(lcSelect, LEN(lcSelect) - 1)+" FROM tmpCursor INTO RealCursorName READWRITE"
&lcSelect
Both were on top onn my head and maybe there are other solution which are better than these.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.