Mysql UNIQUE and .lc server scripts?

Peter Haworth pete at lcsql.com
Thu May 8 20:21:50 EDT 2014


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
>



More information about the Use-livecode mailing list