<div>
Thanks. &nbsp;You put me onto the right process. &nbsp;the style is actually a varchar so I used &quot;where g.style = cast(?QueryPrompt1 as varchar) and all works. &nbsp;Much appreciated. :-)
</div>


Thanks.  You put me onto the right process.  the style is actually a varchar so I used "where g.style = cast(?QueryPrompt1 as varchar) and all works.  Much appreciated. :-)

<div>
<div class="content wysiwyg-content">
Does anyone know how to pass from Bartenders queryprompt into the sql script.<br />
select g.posdesc,g.labl,retail1, b.siz from garment as g<br />
join barcode as b on b.style= g.style<br />
join pricing as p on p.style = b.style and p.pricepoint = b.pricepoint<br />
where g.style = ?QueryPrompt1<br />
The ?Queryprompt is the holder name in the query software bartender supplies for<br />
getting input from the user. &nbsp;If I pass the data directly ie g.style = '2313958' &nbsp;no problem. <br />
The error message I get from the SQL is &quot;Conversion failed when converting the varchar<br />
value '.' to data type int
</div>
</div>


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

Bartender Query prompt

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.

Software

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.