Insert Into Database

Legacy Poster

• December 17, 2014 11:08

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

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • December 24, 2014 04:39

  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.