New topic: Problem with sqlite rsd escaping '&'
<http://forums.realsoftware.com/viewtopic.php?t=47136> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message vfran Post subject: Problem with sqlite rsd escaping '&'Posted: Sun Mar 03, 2013 6:10 am Joined: Mon Dec 07, 2009 7:30 pm Posts: 115 Location: Europe/Italy Simply.. formulaname.text = "Foods & Drinks" I have this for the insert: dr.Column("name") = trim(formulaname.text) db.InsertRecord "formulas", dr db.Commit (works fine and is written to db) Then when trying to populate a popupmenu with the names: sql = "SELECT name FROM formulas ORDER BY name" dim rs as RecordSet = db.SQLSelect(sql) formulaselect.DeleteAllRows formulaselect.AddRow "Select Formula" while not rs.eof formulaselect.AddRow rs.Field("name").StringValue rs.MoveNext wend the '&' in the name is removed turning "Foods & Drinks" into "Foods Drinks". Can anyone point me to the problem? 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]
