Search found 19 matches

by pherms
Tue Jun 02, 2020 10:39 am
Forum: General Discussions
Topic: SQL statements variable on *.mdb
Replies: 5
Views: 2451

Re: SQL statements variable on *.mdb

Hi Mcblogiz, The query "Select * from rgaminu_grupe" should indeed give you some results. Is your rgaminu_grupe an existing table in your Access database? Does the query work in Access itself? Another issue you may have is you are thrying to put the result of this query in a variable. However, the q...
by pherms
Tue Jun 02, 2020 10:20 am
Forum: General Discussions
Topic: AS-400 and Nicelabel
Replies: 1
Views: 86

Re: AS-400 and Nicelabel

Hi Kreinafine2, If you are able to setup an ODBC connection to your AS-400 system, than you should be able to connect Nicelabel to your AS-400. Assuming you are using Nicelabel designer, you can use the database wizard to connect to this ODBC datasource and go from there. To query the data, so you c...
by pherms
Fri May 29, 2020 10:01 am
Forum: Label Design & Printing
Topic: sending printer preferences to printer
Replies: 2
Views: 168

Re: sending printer preferences to printer

Hi Mytch, Thank you for your reply. Yes the data needs to be variable as it is different for each print job. I went down the "Send Data to TCP/IP Port" route, because I have found the technical manual of this specific printer and I think I have found how to set the delay on the printer. I have to te...
by pherms
Fri May 22, 2020 4:52 pm
Forum: Label Design & Printing
Topic: sending printer preferences to printer
Replies: 2
Views: 168

sending printer preferences to printer

Hi, I am working with a Hitachi RX-SD160W printer. I have the Nicelabel driver installed. The installed version of the driver is: 8.2.00.18455. In this driver there is a preferences page. On this preference page there is a print delay value and it allows me to delay the start of the print. I am usin...
by pherms
Wed Apr 22, 2020 9:15 am
Forum: Label Design & Printing
Topic: best practices question
Replies: 8
Views: 864

Re: best practices question

I was already convinced of layers in Nicelabel when I first read about it. It seems to be an awesome feature and we are in the process of upgrading from Nicelabel 2017 to 2019. It is somewhat of a bummer when you work with 2 or more people on a solution and one of them makes little adjustments to th...
by pherms
Fri Apr 17, 2020 11:44 am
Forum: Label Design & Printing
Topic: best practices question
Replies: 8
Views: 864

Re: best practices question

Hi Highfrost and Kyleodonnell, Thank you for your answers. I have not done much development work in Nicelabel 6 or earlier, although we are in the processing of migrating to Nicelabel 2017 or up. But the things I a had to do in the older versions are so much more work than in the versions from 2017 ...
by pherms
Wed Apr 15, 2020 9:53 am
Forum: Label Design & Printing
Topic: best practices question
Replies: 8
Views: 864

best practices question

Hi, I am currently working on and maintaining a Nicelabel 2017 solution and due to some regulation requirements I need to add some additional data to the labels in that solution. While I am working on these questions keep on bothering me: - When you have multiple production lines, what is the best w...
by pherms
Mon Jan 20, 2020 5:28 pm
Forum: Label Design & Printing
Topic: label size is different between screen and label
Replies: 2
Views: 1841

Re: label size is different between screen and label

Hi, Thank you for your answer. I guess the wrong driver is indeed installed. When I look at which driver is installed, windows says Zebra ZT510-300dpi ZPL, but when I print the print settings on the printer, the print says: ZTC 105SL-200dpi. I will contact our tech department to change the driver to...
by pherms
Mon Jan 20, 2020 12:09 pm
Forum: Label Design & Printing
Topic: label size is different between screen and label
Replies: 2
Views: 1841

label size is different between screen and label

Hi, I am using nicelabel 2017 to design a label to be printed on a Zebra ZT510-300dpi printer. The physical label size in 70mm x 30mm on a roll in portrait mode. I have created a new label, so that it can be printed on this printer. Size is set to 70mm x 30mm on a roll in portrait mode. On screen th...
by pherms
Tue Dec 17, 2019 12:05 pm
Forum: Label Printing Integration & Programming
Topic: Values in combobox based on SQL query
Replies: 2
Views: 2336

Re: Values in combobox based on SQL query

Hi, I have solved this issue myself. What I did was the following. I have added a "set variable action" to the bottom of my list of actions on my search button and gave it a logical name (screenshot 1). I have used this variable in my query in the Dynamic datamanager (screenshot 2). https://www.pasc...
by pherms
Thu Dec 12, 2019 5:35 pm
Forum: Label Printing Integration & Programming
Topic: Values in combobox based on SQL query
Replies: 2
Views: 2336

Values in combobox based on SQL query

Hi, I hope anybody can help me. I am building a solution in Nicelabel 2017. What I have so far is a search box, where I can enter an article number. When you press on the search button a query is run, which gets the data from an external ODBC datasource. The data pulled from the ODBC datasource is t...
by pherms
Wed Dec 11, 2019 1:33 pm
Forum: General Discussions
Topic: upgrading to nicelabel 2019.2
Replies: 1
Views: 5162

upgrading to nicelabel 2019.2

Hi, Currently we are running Nicelabel 2017 (v17.3). Now Nicelabel 2019 v2 has been released and we are thinking about upgrading our current version to the 2019 version. Reading the upgrade manual, it is supposed to be very easy, but I do have some questions. 1. Are the solutions, we have build in 2...
by pherms
Wed Nov 27, 2019 1:57 pm
Forum: Label Printing Integration & Programming
Topic: assign sql data to variables
Replies: 2
Views: 2265

Re: assign sql data to variables

I have found a solution to my problem. When you use the action "Execute SQL Statement" you can choose the option to "Iterate for every record". You have to create variables with the same name as the fields name in the database. Then you can either connect your label fields to these newly created var...
by pherms
Tue Nov 26, 2019 4:38 pm
Forum: Label Printing Integration & Programming
Topic: assign sql data to variables
Replies: 2
Views: 2265

assign sql data to variables

Hi, I am trying to optimize the Nicelabel solution we have built last year. At the moment we run a bunch of select queries, which select only one database field and we put the result in a variable. What I want to do to optimize this is run 1 query where I select the fields I need, and assign the fie...
by pherms
Fri Oct 11, 2019 12:41 pm
Forum: General Discussions
Topic: Tooltip in forms
Replies: 2
Views: 2975

Re: Tooltip in forms

:oops:
Soo easy.

Thank you.