updating databased record after print
I have a bartender label I created for which I am pulling data from a database. I am pulling the initial value to create the starting serial number and the user enters how many labels they need. From there it gives them the sequence of AC000001 + 20 if the user needs 20 labels. Now I want to update that new sequence in the database so next time they try to print it will start at that sequence, ex AC000021. I went ahead and clicked on the "update record when data source changes" under the data sources in the barcode properties but I do not see that field updating with the newest sequence.
-
You need to configure BarTender to write that field data back into the database at the end of the print job.
I would suggest you look at running an Action at that time either from the Data Entry Form > Properties > Action button (probably on Form Closed as shown below)
or else via File>BarTender Document Options>Document Level Actions, again probably when the Print Job Sent.
I tend to use the former method.
0 -
I was looking at this function but how do I get the update to happen to the correct field in my database. Example my table has customer ABC1 SEQU1111111, ABC2 SEQU2222222, ABC3 3333333. So when I print out labels for customer ABC2 I want the sequence to update for ABC2 not to update for the others.
0 -
You would need to configure the Where command to the variable that contains the ABC2 and tick the field to be updated inserting the variable to give the new value. So something like this although I am just using Global Variables as I am just connected to a blank label and so have no Variables/fields to reference
-1
Iniciar sesión para dejar un comentario.
Comentarios
3 comentarios