Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to print some characters in LabelView 8.01

Status
Not open for further replies.

klabaza

MIS
Aug 3, 2005
59
Hi people.

I have 1 problem with LabelView, I have been searching around with no solution, I still waiting for LabelView support to answer me, the doc doesn't say anything about, hope someone here can help me with this small issue.

We are creating a warehouse system in the company, this system have a special module that interacts with LabelView 8.01, every time the users create labels for our finish-good, and wants to print the labels, the user just press a button and automatically the system search for the new records on the DB(mysql) built the ascii file called "labels.cmd" following LabelView doc and send this records to the printer.

This is a example:

LABELNAME="C:\labels\ow.LBL"
DATATYPE=FIXED
FIELD=UPC@1-16
UPC="0000000221600001"
FIELD=MODEL@1-10
MODEL="2216"
FIELD=MODELUPC@1-10
MODELUPC="2216"
FIELD=DESC@1-35
DESC="55" Console"
LABELQUANTITY=1
QUITAPP

This module is working as desire, but the company design tv consoles, and some products description are like:

55" TV Console

U can see the ("), the LabelView doc say:

*Be careful to include the spaces.

*Using quotation marks (" ") around field names is optional, unless you are adding spaces in the
fields.

*A semicolon ( ; ) indicates remarks or comment statements; characters that appear on a line after a semi-colon will be
ignored.

*Command files are NOT case sensitive.

My problem is how on earth I will print the (")?

I can print (') this one, but not (").

If someone here have experience with labelview and knows how to handle this I will appreciate the advised really, the system is almost ready for production but without this is not ready.

Thanks all for your time!!!

Clients Windows XP pro sp3.
 
klabaza,
are there escape characters listed in their documentation?
should be an ascii code that indicates to the printer that the following character is an actual character and not a control character.

regards,
longhair
 
klabaza,

yes, We've had that issue with command files as well. I know exactly what your problem is, and as far as I know you need to remove those characters from your data. I would like to hear if there is another solution, but our rule of thumb is not to use quotes in fields. I think it is the downside of the cmd file.

Personally if I could recommend, since I saw you mention SQL DB, you can create an OLE DB connection in labelview to connect to your database, this then lets you pick tables and fields from the database...much better process...

In LV go to Options/Config > Ole DB manager tab...click NEW, choose SQL server, then follow the steps.... and name the connection.

When you are done, when you add a field your data source will be OLE DB ( instead of "When printed"), connection will be the name of the DB, database will actually be the table in the DB and finally your field.

It's much better, check up on Help for OLE DB for more help, this also works great with MS Access DB, ODBC etc.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top