LiveCode Forums.

Posted: **Sun Feb 07, 2016 8:24 pm**

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

Posted: **Sun Feb 07, 2016 8:47 pm**

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 & "';")

LiveCode Forums.

Need to use single quotes ' '

Need to use single quotes ' '

Re: Need to use single quotes ' '