Jump to content

Recommended Posts

Posted

In my SQL database I have one column set to unique, if I try to enter data that is not unique I get a return code of 19. This lets me kow there was a constraint error which I can use, but what looks better is in the console it will actually say something like --> Error: column Barcode is not unique. How can I get get access to the full description of the error in my program?

Hope that makes sense??

Thanks again

Mark

Posted

Use _SQLite_ErrMsg()

This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Posted

Use _SQLite_ErrMsg()

Hi Again, and thanks again!

When I do that I get "library used incorrectly", is there a way to get what appears on the console "column Barcode is not unique"

Regards

Mark

Posted

Well I thought I would tidy the code a bit before posting, tested it and the _SQlite_ErrMsg returned with the exact same message I got in the console. Not sure what happens in my messy code but I will have a look!

So thanks guys I can sort it from here.

Regards

Mark

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...