https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/102453&feed=atom&action=history
Microsoft KB Archive/102453 - Revision history
2024-03-28T17:09:00Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/102453&diff=349562&oldid=prev
X010: Text replacement - "&" to "&"
2020-07-21T11:25:18Z
<p>Text replacement - "&" to "&"</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:25, 21 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l16">Line 16:</td>
<td colspan="2" class="diff-lineno">Line 16:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In FoxBASE+, to determine if a character field is blank, use the LEN() function in an IF statement, as follows:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In FoxBASE+, to determine if a character field is blank, use the LEN() function in an IF statement, as follows:</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><pre> IF LEN(TRIM(x)) = 0 &<del style="font-weight: bold; text-decoration: none;">amp;</del>&<del style="font-weight: bold; text-decoration: none;">amp; </del>where x is the blank memory variable</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><pre> IF LEN(TRIM(x)) = 0 && where x is the blank memory variable</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>This function will also return the desired results when executed in all versions of FoxPro.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>This function will also return the desired results when executed in all versions of FoxPro.</div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l23">Line 23:</td>
<td colspan="2" class="diff-lineno">Line 23:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In FoxPro version 1.02 and later, the EMPTY() function may be used as follows:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In FoxPro version 1.02 and later, the EMPTY() function may be used as follows:</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><pre> IF EMPTY(x) &<del style="font-weight: bold; text-decoration: none;">amp;</del>&<del style="font-weight: bold; text-decoration: none;">amp; </del>where x is still the blank memory variable</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><pre> IF EMPTY(x) && where x is still the blank memory variable</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>NOTE: The EMPTY() function is available only in FoxPro for MS-DOS versions 1.02 and later and in FoxPro for Windows.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>NOTE: The EMPTY() function is available only in FoxPro for MS-DOS versions 1.02 and later and in FoxPro for Windows.</div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/102453&diff=47103&oldid=prev
3155ffGd: importing KB archive
2020-07-18T15:02:44Z
<p>importing KB archive</p>
<p><b>New page</b></p><div>{|<br />
|width="100%"|<br />
= How to Test for a Blank Character Variable =<br />
<br />
'''ID: Q102453'''<br />
<br />
The information in this article applies to:<br />
<br />
* Microsoft FoxPro for Windows, versions 2.5x, 2.6, 2.6a<br />
* Microsoft FoxPro for MS-DOS, versions 1.01, 1.02, 2.0, 2.5x, 2.6, 2.6a<br />
* Microsoft FoxBASE+ for the Macintosh, version 2.01<br />
* Microsoft FoxBASE+ for MS-DOS, version 2.1<br />
<br />
=== FoxBASE+ ===<br />
<br />
In FoxBASE+, to determine if a character field is blank, use the LEN() function in an IF statement, as follows:<br />
<br />
<pre> IF LEN(TRIM(x)) = 0 &amp;&amp; where x is the blank memory variable<br />
</pre><br />
This function will also return the desired results when executed in all versions of FoxPro.<br />
=== FoxPro versions 1.02 and Later ===<br />
<br />
In FoxPro version 1.02 and later, the EMPTY() function may be used as follows:<br />
<br />
<pre> IF EMPTY(x) &amp;&amp; where x is still the blank memory variable<br />
</pre><br />
NOTE: The EMPTY() function is available only in FoxPro for MS-DOS versions 1.02 and later and in FoxPro for Windows.<br />
=== FoxPro versions 2.6 and Later ===<br />
<br />
In FoxPro version 2.6 and later, the ISBLANK() function may be used instead.<br />
<br />
For information about the ISBLANK() function, refer to the FoxPro Help file or the following article in the Microsoft Knowledge Base:<br />
<br />
<pre> ARTICLE-ID: Q99095<br />
TITLE : ISBLANK() Function Provides Additional Null Value<br />
Support<br />
</pre><br />
Additional reference words: FoxDos FoxWin 2.x 2.00 2.10 2.50 2.50a 2.50b nothing field variable foxbase+/mac KBCategory: kbenv kbprg KBSubcategory: FxenvMemory<br />
|}<br />
<br />
{|<br />
|width="100%"| <br /><br />
Last Reviewed: June 27, 1995<br /><br />
<span>© 1999 Microsoft Corporation. All rights reserved. Terms of Use.</span><br /><br />
|}</div>
3155ffGd