Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get empty variable names
Message
From
26/08/2005 11:01:02
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Get empty variable names
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01044317
Message ID:
01044317
Views:
63
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;
Next
Reply
Map
View

Click here to load this message in the networking platform