Mysql UNIQUE and .lc server scripts?

JOHN PATTEN johnpatten at
Thu May 8 19:18:42 EDT 2014

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

More information about the Use-livecode mailing list