Creating Query Prompt in Custom SQL Statement フォローする
I use Bartender to print price labels, I have a custom SQL statement to add VAT onto my prices, this stops the option to select a filter and I need to write one in to the statement.
I would like to create a query prompt for the barcode so that I can search for and print by barcode.
I have read and watched as many tutorials as I can find and got to this point with my SQL statement
SELECT p.name, p.code, p.pricesell+(p.pricesell * t.rate) as withTax
FROM products p, taxes t
WHERE p.taxcat = t.category;
WHERE p.code = '?Barcode'
The first 3 lines add the VAT and work on their own, the forth line that I have added to create the query prompt breaks everything, so help please.