New topic: SQL Syntax Error?
<http://forums.realsoftware.com/viewtopic.php?t=47145> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message RicSum Post subject: SQL Syntax Error?Posted: Mon Mar 04, 2013 4:38 am Joined: Fri Jun 05, 2009 4:54 pm Posts: 419 Location: London, England Can someone please point out the syntax error in the single line of code below: sql="Insert into SettingsTable (Sonames) Values ('"+sqlify(fldName.text)"')" It works perfectly on the line of code below, but when I change it to the very top line of code in this post - it has a syntax error? sql="Insert into Incidents (I_Number, I_Type, I_Date, I_Name, I_Address) Values ('"+sqlify(fldI_Number.text)+"','"+sqlify(fldIType.text)+"','"+sqlify(fldIDate.text)+"','"+sqlify(fldIName.text) +"','"+sqlify(fldIAddress.text)+"')" P.S (SQLify is a method I have - Method Name=SQLify, Parameters=source as String, Return Type=String) dim completed as string completed=ReplaceAll(source, "'", "`" ) completed=ConvertEncoding(completed, encodings.WindowsANSI) return completed Thanks in advance. _________________ RealStudio Professional Edition 2011 Release 4 & 2012 Release 1.2 Developing on OS X 10.8 (Mountain Lion) Deploying on Windows XP / 7 / 8 Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
