Need to use single quotes ' '

[parsec]

can some one point me to the right direction
Need to use single quotes ' ' in the query bellow in order for my query to work in the MsSQL server as the column is VCHAR and have to include the ' ' like this "SELECT * FROM Inventory_Prices WHERE PLU_Number = " 111111111 '

Code: Select all

global gConID
on mouseUp
   put"SELECT * FROM Inventory_Prices WHERE PLU_Number = " & field "id"  into tRecordSet

thank you

[Dixie]

An example of using single quotes in a SQL query from liveCode...

Code: Select all

get revDataFromQuery( tab, return, theDataRef, "SELECT * FROM calloutcatsub where contract='" & contractarea & "';")