<div>
You give the reason yourself: product.case_qty is a numeric field. You can't use alltrim() - which is a string function - on a numeric value.<br />
<br />
While an N(5) field stores it's numeric values in string format in the dbf file, it is converted to numeric (double) in memory, so your if found() else endif is setting HoldThisSAPCaseQty to a numeric value in the if case and the string &quot;FNF&quot; in the else case.<br />
<br />
You would need STR(product.case_qty) to make HoldThisSAPCaseQty a string in both cases.<br />
<br />
Bye, Olaf.<br />

</div>


You give the reason yourself: product.case_qty is a numeric field. You can't use alltrim() - which is a string function - on a numeric value.

While an N(5) field stores it's numeric values in string format in the dbf file, it is converted to numeric (double) in memory, so your if found() else endif is setting HoldThisSAPCaseQty to a numeric value in the if case and the string "FNF" in the else case.

You would need STR(product.case_qty) to make HoldThisSAPCaseQty a string in both cases.

Bye, Olaf.


<div>
Hi Olaf,<br />
<br />
I was only trying to convert it to a string because I was not sure how to get it embedded in:<br />
strLbl = strLbl + &quot;^FO25,65^BY.33^B3N,N,30,N<wbr />,N^FD&quot; + AllTrim(HoldThisSAPCaseQty<wbr />) + AllTrim(label.cust_prod) + &quot;^FS&quot; + CRLF<br />
<br />
What is the syntax for adding that field into the statement if I want to keep it numeric?<br />
<br />
Thanks,<br />
<br />
Charlie
</div>


Hi Olaf,

I was only trying to convert it to a string because I was not sure how to get it embedded in:
strLbl = strLbl + "^FO25,65^BY.33^B3N,N,30,N,N^FD" + AllTrim(HoldThisSAPCaseQty) + AllTrim(label.cust_prod) + "^FS" + CRLF

What is the syntax for adding that field into the statement if I want to keep it numeric?

Thanks,

Charlie

<div>
<div class="content wysiwyg-content">
Hi, I am trying to figure out what the correct syntax is to fix the error in the attached .jpg. I am using VFP6.<br />
<br />
Thanks in advance,<br />
<br />
Charlie <a href="https://filedb.experts-exchange.com/incoming/2011/12_w50/528911/vfp6error.jpg" target="_blank" title="VFP6 Error (199 KB)"><img alt="VFP6 Error" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2011/12_w50/800_528911/vfp6error.jpg" /></a>
</div>
</div>


vfp6error.jpg

Hi, I am trying to figure out what the correct syntax is to fix the error in the attached .jpg. I am using VFP6.

Thanks in advance,

Charlie 

VFP 6 (Visual Foxpro 6) Error

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.