Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IsBlank()
Message
From
21/01/2003 18:41:55
 
 
To
21/01/2003 18:27:27
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00744047
Message ID:
00744054
Views:
9
>maybe someone has an idea
>
>i sometimes work with long strings (i.e. to build an sql or filter command) i then check that string if it is empty with "IsBlank(StrToCheck)".
>
>i gues there is a limitation in IsBlank() since it sometimes triggers the error "string to long to fit".
>
>is there a solution to this problem (i work with vfp6 sp5)?
>
>thanks for all your help in advance.

What my understanding, ISBLANK() is usually use against a field from a table. If you wish to detect if a string is empty, you may check LEN() function such as:
IF LEN(lcString)=0
   * Blank
ENDIF
or
IF LEN(ALLTRIM(lcString))=0
   * Blank
ENDIF
to be more bullet proof in case you are handling that string with spaces.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform