Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP SQL bug?
Message
De
08/01/2001 13:23:27
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00460685
Message ID:
00460694
Vues:
12
Paul,

SQL takes the liberty of opening tables in other work areas and under other aliases to do it's job. Any time you use RECNO("MyTable") you leave yourself open to getting the wrong results.

Are you just after the first record (or was that an example)? There are work-arounds with COPY TO, etc. but they have more steps.


>The following statement will retrieve the correct record in VFP
>
>SELECT * FROM HISTORY WHERE RecNo() = 1 INTO CURSOR ItemList0
>
>But the following statement:
>
>SELECT * FROM HISTORY WHERE RecNo("History") = 1 INTO CURSOR ItemList0
>
>will retrieve all records from History in VFP5 but 0 records in VFP6
>
>Anybody knows why? Just a bug?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform