×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

How to print some characters in LabelView 8.01

How to print some characters in LabelView 8.01

How to print some characters in LabelView 8.01

(OP)
  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.
 

RE: How to print some characters in LabelView 8.01

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

RE: How to print some characters in LabelView 8.01

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.

 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close