Hi Agnes,
It's strange behavior...
Try:
SELECT;
Cur1.II AS II3,;
Cur1.II AS II1,;
Cur1.II AS II2;
FROM Walker AS Cur1
The LAST column is correct...
MartinJ
>Hi All,
>
>I like to show you this days problem with VFP (7.0 and 8.0) on a W2K machine
>
>Check the result of
>
>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 II2;
> FROM Walker AS Cur1
>
>
>Do you agree that the result is like
>
>2 2
>0 NULL
>0 NULL
>0 NULL
>1 1
>
?
>Any ideas what coul lend to this result?
>
>TIA
>Agnes