Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wrong result od SQL Select
Message
 
To
19/03/2004 06:26:07
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00887816
Message ID:
00887824
Views:
6
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
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Reply
Map
View

Click here to load this message in the networking platform