Update via VB Script SQL database from the records used to print labels

锋权 周

• 2019年06月04日 16:15
• 編集済み

I am running Bartender 2019 R2 version. This problem still exists. What is the reason for this?

Print the data in the selected recorder and update its database value，

Dim SQL
Dim ordno
Set objConn = CreateObject("ADODB.Connection")
set rs = createobject("adodb.recordset")
connstr="DSN=SQL Anywhere 11 Demo;UID=dba;PWD=sql"
objConn.Open connstr
ordno=Format.Objects("print_Description").Value

SQL ="UPDATE products set name='print_oK' where description='" & ordno & "'"

objConn.execute SQL
objConn.close

Why is this statement not updated, is it caused by the assignment of the selected value?
If you write him as a value, you can successfully execute and update the database without any problem.
SQL ="UPDATE products set name='print_oK' where description='V-neck"

0

• 

  K T

  ★ BarTender Hero ★

  • 2019年10月07日 11:41

  I think the value of the object has changed since the end of printing. The object value is not found in the products table. It is recommended to add a line "msgbox ordno" before the UPDATE to check the value of ORDNO.

  0
• 

  锋权 周

  ★ BarTender Hero ★

  • 2020年01月01日 06:20

   

   

  at the bartender 2019 R5 have a new function

  how i can update from bartender name funciton value

  

  0

サインインしてコメントを残してください。