New topic: RB Update SQL SERVER Database Record
<http://forums.realsoftware.com/viewtopic.php?t=47542> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message p0wn3d Post subject: RB Update SQL SERVER Database RecordPosted: Mon Apr 08, 2013 6:05 am Joined: Sun Oct 28, 2012 4:54 am Posts: 189 Location: Herts, UK Hi I can't find any example in the LR for updating a database record. This code works fine for creating my Table and fields Dim sql As String sql = "CREATE TABLE Team (ID INTEGER NOT NULL, Name TEXT, Coach TEXT, City TEXT, PRIMARY KEY(ID));" DB.SQLExecute(sql) Looking for a RB sql statement to "Update Table Team -> 'Coach' -> WHERE 'ID'= "8" Thanks _________________ Real Studio 2012 R2 SysInfo BackTrack Linux/BackBox Linux/Debian Lenny/Windows 7/Windows 8/OpenWRT/OpenBSD 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]
