>I tried to put a function in my View.(v_resident)
>
<snip>>
>
>I have 2 problems.
>
>1) it is very slow
>2) the index of the column is the controlsource ( cf Advisor 05/2004. Grid simplify )
> Index On date caractere is different of Date.
>
>The format dates in my session form environment is "Short".(Windows parameters)
>When I use "V_resident.dsortie" as ctrlsource (datetime) i use the short format.
>When I use date shorts jj/mm/aa and Format HH:mm all is ok.
>
>How put by programming the format shorts and Format hours For my customers ?
Bernhart,
UDF's slow down queries considerably. See if you can use following expression in the view directly. It also is independent of any date or/and time settings.
SUBSTR(TTOC(ltDt,1),7,2) + "/" + ;
SUBSTR(TTOC(ltDt,1),5,2) + "/" + ;
RIGHT(SUBSTR(TTOC(ltDt,1),1,4), IIF(lCentury,4,2)) + " " + ;
SUBSTR(TTOC(ltDt,1),9,2) + ":" + ;
SUBSTR(TTOC(ltDt,1),11,2)
--sb--