Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field value
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00266536
Message ID:
00266542
Views:
27
>I need to loop thru all the fields in a table to see if they are blank. I know I can use Field but that returns a string which doesn't allow to check to value. How to I change that a string so that I can check if the field is empty.
* AnyBlanks.prg
LOCAL llBlank, lcField,laFlds(1)
SELECT TheAlias
AFIELDS(laFlds)
FOR lnCnt = 1 TO ALEN(laFlds,1)
   lcField = "EMPTY(laFlds(lnCnt))"
   llBlank = &lcField
   IF llBlank
      EXIT
   ENDIF
ENDFOR
RETURN llBlank
Previous
Reply
Map
View

Click here to load this message in the networking platform