How to report and error to user?

This is the place to post technical queries about SQL Yoga

Moderators: FourthWorld, heatherlaine, Klaus, robinmiller, trevordevore

Post Reply
trevordevore
VIP Livecode Opensource Backer
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?

Post by trevordevore » Fri Oct 11, 2013 2:16 pm

[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?
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

trevordevore
VIP Livecode Opensource Backer
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?

Post by trevordevore » Fri Oct 11, 2013 2:16 pm

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

Post Reply

Return to “SQL Yoga”