Adding Barcode Start/Stop Characters??? 1

[Bugboy]

Very newby question: We use a business software program called Made2Manage. It uses VFP to create or edit custom reports. I have a shipping label that needs barcode added to several fields. The required barcode is Code39 which uses an * as a start and stop character. In addition, each of these fields needs an alpha prefix character. I was successful in getting 3 out of 4 fields to properly display the barcode in the following manner:

Expression: "*P"+(RTRIM)fpartno))+"*"
Format: Character, Upper Case, left justify
Display Font: Code39 narrow


THE PROBLEM IS ONE FIELD WILL NOT ALLOW ANY EDITING WITHOUT GIVING ME ERRORS!!!!

If I simply put FSHIPQTY as the expression, it will display the barcode without the S/S characters, which is worthless, as it will not scan.

If I change it to: "Q"+FSHIPQTY I get an error when I try to print a label that says, "Function argument value, type, or count is invalid.

All of the other fields allowed this edit without errors.

Any Ideas???????

 

[ramani]

just use in the place, fshipqty... ALLTRIM(STR(FSHIPQTY)) ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com

 

[Bugboy]

Ramani,
Thanks for your very quick reply. Can you now tell me exactly how to add the "*Q" at the beginning and the "*" at the end of the value returned from FSHIPQTY. Would it look like this:

"*Q"+ALLTRIM(STR(FSHIPQTY))+"*"

I need the barcode display to have:
*Q(the value of fshipqty)*

Again, thanks for your quick reply.

 

[ramani]

Yes that is what you should put.
"*Q"+ALLTRIM(STR(FSHIPQTY))+"*"

For all numeric, you should use ALLTRIM(STR(myNumeric))
ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com

 

[Bugboy]

Ramani,
Thanks so much for you immediate and accurate responses. Your "fix" worked perfectly and got me out of a jam! I really do appreciate your timely help. I also appreciate not being flamed for being so unfamiliar with VFP. We use it so very little, it would be silly for me to spend much time learning it all. So it is nice that there are some that have learned it all that are willing to help the rest of us.

Thanks again!

Bryan