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

Brooks Norton

• 2026年03月19日 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 ★

  • 2026年04月27日 16:19

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

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

  0

请先登录再写评论。