revdb_connectionerr

[Peter Haworth]

Thanks for the replies and clarification.  I do normally check the  
result of each db call but came across a circumstance where  
revdb_connectionerr would have been useful.

I like the idea of using try/catch for all db operations and will  
implement that but I guess it relies on knowing what all the possible  
error messages can be.  Is that dependant on which sql implementation  
I'm using (I use sqlite).

However, that gives rise to another question.  I'm using try/catch in  
other places to execute rev commands that are built programmatically.   
All works fine but the error messages that are caught are full of  
sequences of three numbers separated by commas as well as the original  
statement and an English error message (sorry don't have any examples  
immediately to hand).  Does anyone know what those numbers indicate?

Pete Haworth








On Aug 11, 2010, at 8:12 AM, use-revolution-request at lists.runrev.com  
wrote:

> Message: 9
> Date: Tue, 10 Aug 2010 13:17:32 -0700
> From: Bob Sneidar <bobs at twft.com>
> Subject: Re: revdb_connectionerr
> To: How to use Revolution <use-revolution at lists.runrev.com>
> Message-ID: <13879E4D-8EAE-45D6-95AC-25601C3DF4E3 at twft.com>
> Content-Type: text/plain; charset=us-ascii
>
> Agreed. In fact, I put all database operations inside a try/catch  
> structure so as not to assault the end user with error dialogs that  
> they don't know what to do with. If you are making a TON of calls in  
> your app, you may want to consider writing a special database error  
> function which knows how to handle all the errors you want in a way  
> that the end user (and your app) can work with.
>
> For instance, a "Database temporarily unavailable. Try again?"  
> dialog that gives the user a chance to call IT and have them get the  
> DB back online without dumping your app mid transaction.
>
> Bob