[This post is an archive from the old SQL Yoga forums]
I have a SQLyoga query which operates on a user supplied string which is applied to the MATCH function on a FTS table.
It is possible that the supplied string is malformed and I want to inform the user of this, specifically.
It is too complicated to parse all variations of possible malformations so I am happy to let SQLITE throw the query out.
I follow the query with the normal test on the result to see if it contains "err" and exit if it does.
However I would like to specify what the problem was rather than "an error with SQL has occurred" which is what comes up on the answer dialog.
Is there anyway I can customise this message?
How to report and error to user?
Moderators: FourthWorld, heatherlaine, Klaus, robinmiller, trevordevore
-
- VIP Livecode Opensource Backer
- Posts: 1005
- Joined: Sat Apr 08, 2006 3:06 pm
- Location: Overland Park, Kansas
- Contact:
How to report and error to user?
Trevor DeVore
ScreenSteps - https://www.screensteps.com
LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder
ScreenSteps - https://www.screensteps.com
LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder
-
- VIP Livecode Opensource Backer
- Posts: 1005
- Joined: Sat Apr 08, 2006 3:06 pm
- Location: Overland Park, Kansas
- Contact:
Re: How to report and error to user?
SQL Yoga doesn't provide any error customization options and usually just reports what the database driver reports to SQL Yoga.
Trevor DeVore
ScreenSteps - https://www.screensteps.com
LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder
ScreenSteps - https://www.screensteps.com
LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder