BT2022: Error using query prompt with custom SQL

Blas González

• June 23, 2022 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 ★

  • June 23, 2022 11:19

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

  0
• 

  Xabier Clemente

  Moderator

  ★ BarTender Hero ★

  • July 13, 2022 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

Please sign in to leave a comment.