Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Get empty variable names
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Get empty variable names
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01044317
Message ID:
01044317
Vues:
62
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;
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform