Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wrong result od SQL Select
Message
From
19/03/2004 06:26:07
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Wrong result od SQL Select
Miscellaneous
Thread ID:
00887816
Message ID:
00887816
Views:
47
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
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.

Off

There is no place like [::1]
Next
Reply
Map
View

Click here to load this message in the networking platform