Need to use single quotes ' '

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

Post Reply
Posts: 27
Joined: Fri Jan 09, 2015 5:24 pm

Need to use single quotes ' '

Post by parsec » 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

Livecode Opensource Backer
Livecode Opensource Backer
Posts: 1336
Joined: Sun Jul 12, 2009 10:53 am
Location: Bordeaux, France

Re: Need to use single quotes ' '

Post by Dixie » 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 & "';")

Post Reply

Return to “Databases”