Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Get empty variable names
Message
De
26/08/2005 11:33:35
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01044317
Message ID:
01044338
Vues:
8
Ignore!

>How to get empty veriables names.(Which veriables still Whole empty.
>i want empty names of obt01 .........to obt24 for max01........to max24
>
>SELECT Examtran.scode, Examtran.lcode, Examtran.sec, Examtran.examcode,;
>  Examtran.code, Examtran.max01, Examtran.max02, Examtran.max03,;
>  Examtran.max04, Examtran.max05, Examtran.max06, Examtran.max07,;
>  Examtran.max08, Examtran.max09, Examtran.max10, Examtran.max11,;
>  Examtran.max12, Examtran.max13, Examtran.max14, Examtran.max15,;
>  Examtran.max16, Examtran.max17, Examtran.max18, Examtran.max19,;
>  Examtran.max20, Examtran.max21, Examtran.max22, Examtran.max23,;
>  Examtran.max24, Examtran.obt01, Examtran.obt02, Examtran.obt03,;
>  Examtran.obt04, Examtran.obt05, Examtran.obt06, Examtran.obt07,;
>  Examtran.obt08, Examtran.obt09, Examtran.obt10, Examtran.obt11,;
>  Examtran.obt12, Examtran.obt13, Examtran.obt14, Examtran.obt15,;
>  Examtran.obt16, Examtran.obt17, Examtran.obt18, Examtran.obt19,;
>  Examtran.obt20, Examtran.obt21, Examtran.obt22, Examtran.obt23,;
>  Examtran.obt24;
> FROM ;
>     examtran;
> WHERE  Examtran.examcode = ( "August 05" );
>  .and.!empty(max01).and.!empty(max02);
> ORDER BY Examtran.lcode, Examtran.sec;
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform