Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement