Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Found VFP5 bug - please confirm
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00164806
Message ID:
00164823
Vues:
20
>CREATE TABLE mytest (tnum N(6) NULL , tdate D)
>INSERT INTO mytest (tnum, tdate) VALUES (.NULL., {11/15/98})
>BROW FOR mytest.tnum = 5 AND mytest.tdate > {10/31/98}
>On my system - the record incorrectly appears in the browse window! Closing,
>reopening, etc. doesn't change it. SQL Select and other "For" functions such as
>SUM, COUNT, etc. seem to work correctly.

Interesting. I think I may tag this one as "By design", but I'll bounce it upwards and see what happens.

I may be thinking about this incorrectly, but I think when it gets to the FOR condition, the test comes out as:
mytest.tnum = 5 AND myTest.tDate > {^1998/10/31}
.NULL. = 5 AND {^1998/11/15} > {^1998/10/31}
.NULL. AND .T.
.NULL.
And if you insert several other lines, and then type BROWSE FOR .NULL. in the command window shows only the line which you added having the .NULL.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform