Need help with custom SQL that will prompt user for work order

Brooks Norton

• March 19, 2026 16:24

I have this to start…

SELECT [Date_Code]

FROM [dbo.Part_Serial_Number

WHERE [Work_Order] = ?

But the Filter tool says incorrect syntax near the ?.

What is the correct syntax to cause a prompt for user input?

Thanks

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • April 27, 2026 16:19

  I think you are missing the name of the query/filter to use, eg

  SELECT * FROM [Document1] WHERE [Field 1] = ?QueryPrompt1

  0

Please sign in to leave a comment.