Hi John, What's in the result after calling revExecuteSQL to issue your INSERT statement? You should get either an integer count of the number of rows inserted or an error message.
Pete lcSQL Software <http://www.lcsql.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Thu, May 8, 2014 at 4:18 PM, JOHN PATTEN <johnpat...@me.com> wrote: > Hi All, > > I’m using some .lc server scripts to add records to a database from an > app. My database has one field that is UNIQUE. Is it possible to capture > the mySQL message and report it back to the app when text entered for > specific field is not unique? > > The database won’t create the record due to the fact that the filed is not > unique, but it also does not give the user any clue of this fact. > > Thank you! > John Patten > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode