Insert Into Database
Hi,
I'm new on bartender and i need help...
I need to do this:
Every print, i need insert all rows into database values from form:
Example Form:
Operator:
Obs:
SN
Example insert:
insert into table (date,operator,sn) values ("20141217","(form field operator)", "(form field Obs)", SERIALNUMBER1)
insert into table (date,operator,sn) values ("20141217","(form field operator)", "(form field Obs)", SERIALNUMBER12)
insert into table (date,operator,sn) values ("20141217","(form field operator)", "(form field Obs)", SERIALNUMBER123)
Best Regards,
Hélio Moreira
-
Shotaro Ito
★ BarTender Hero ★
BarTender's database connection is read-only. So I recommend to handle that request within custom application - such as
1. The application connect to database, retrieve several records by user request, export as CSV file.
2. Commander detects the CSV file and print the document using that text file.
3. The application update database.
For Commander, refer to this white paper:
http://www.seagullscientific.com/label-software/whitepapers/overview-of-commander-new-201406.pdf
If you need to do that by BarTender's VB script, that's still possible. This post might helps:
http://forums.seagullscientific.com/index.php?/topic/1265-exporting-data-to-excel/
0
Please sign in to leave a comment.
Comments
1 comment