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

Click here to load this message in the networking platform