Hi Fabio,
thank you for that help, works fine.
Do you have an idea if this is reported to MS?
Agnes
>A simple workaround for this VFP behaviour
>( i see it on other SELECT context, but i do not remember if i have open a thread on past time ):
>
>CREATE CURSOR Walker (II I NULL)
>
>INSERT INTO Walker VALUES (2)
>INSERT INTO Walker VALUES (NULL)
>INSERT INTO Walker VALUES (NULL)
>INSERT INTO Walker VALUES (NULL)
>INSERT INTO Walker VALUES (1)
>
>SELECT;
> (Cur1.II) AS II1,;
> (Cur1.II) AS II0,;
> Cur1.II AS II2;
> FROM Walker AS Cur1
>
>
>Fabio
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]