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

Brooks Norton

• 19. März 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 ★

  • 27. April 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

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.