Bartender Query prompt
Posted on 2010-11-17
Does anyone know how to pass from Bartenders queryprompt into the sql script.
select g.posdesc,g.labl,retail1, b.siz from garment as g
join barcode as b on b.style= g.style
join pricing as p on p.style = b.style and p.pricepoint = b.pricepoint
where g.style = ?QueryPrompt1
The ?Queryprompt is the holder name in the query software bartender supplies for
getting input from the user. If I pass the data directly ie g.style = '2313958' no problem.
The error message I get from the SQL is "Conversion failed when converting the varchar
value '.' to data type int