Mysql UNIQUE and .lc server scripts?

[Peter Haworth]

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 <johnpatten at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>