Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
V6s5 - REQUERY() a view for a given SELECT no. of recs
Message
De
16/04/2004 13:09:21
Mike Yearwood
Toronto, Ontario, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00895276
Message ID:
00895626
Vues:
24
This message has been marked as the solution to the initial question of the thread.
>
>I already have it as follows:
>
SELECT "R" + STR(&lcID.) AS iID, &lcText. AS cName ;
>	FROM (THIS.cDBCName + "!" + lcVN) ;
>	WHERE !DELETED() AND EMPTY(&lcPID.) ;
>	ORDER BY &lcOrder. ;
>	INTO CURSOR tQuery
>
Try this instead...

select ... FROM DBF(lcVN) where !deleted()
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform