Insert Into Database

Legacy Poster

• 2014年12月17日 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 ★

  • 2014年12月24日 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

请先登录再写评论。