BT2022: Error using query prompt with custom SQL

Blas González

• 2022年06月23日 09:28

Since I updated to BT 2022, I cannot use query prompts with SQL custom sentence. I got the error "Syntax error near ?". 

 

This worked perfectly fine in BT2021. The database is SQL Server, but it fails as well using OLEDB or SQL Native Client.

Any ideas or workaround?

Kind regards

0

• 

  Blas González

  ★ BarTender Hero ★

  • 2022年06月23日 11:19

  ..It seems to work using an ODBC connection to the database

  0
• 

  Xabier Clemente

  版主

  ★ BarTender Hero ★

  • 2022年07月13日 06:55

  Hello Blas,
  
  Thank you for reaching us via the Community Forums.
  
  As you are aware, this issue has been identified as a software BUG on BarTender 2022 R2, our team has begun working on it and will notify you once the BUG has been resolved on subsequent BarTender 2022 releases.
  
  Please, let us know if there is anything else we can do you for.

  0

请先登录再写评论。