Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Wrong result od SQL Select
Message
 
À
19/03/2004 06:26:07
Lutz Scheffler (En ligne)
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00887816
Message ID:
00887824
Vues:
7
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform