Thanks for the info, Tim. Like you, I have all of my database access and
updating done in stored procedures. I think this is a legacy from my past
Sybase days where this was 'the only way to fly'. At least I can secure all
access to the tables through controlled data management code this way, and
it keeps everything controlled from my application. Also I can move my
entire data management onto the server where the physical data resides,
which means developing thin clients to the database is a reality for me.

Nice to be able to compare design approaches here. Do you have any utility
functions in your applications that run if the application detects any form
of incorrect shut down? Do you have any regularly scheduled processes
running that check the integrity of tables in the database in case something
went wrong?

Myles

===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org

> -----Original Message-----
> From: Tim Ledgerwood [mailto:tim@...]
> Sent: Tuesday, June 22, 2004 7:59 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Re: Evaluating FB 1.5 questions
>
> Oh, one other thing :
>
> The first thing my applications do on startup (before establishing a DB
> connection) is check that the DB exists. In the old "Borland Database
> Engine" terms, it checks to see that the Alias exists and is correctly
> configured. If not, it writes the correct configuration before
> establishing
> a connection.
>
> In the same way, my applications all check for any "show - stoppers"
> before
> trying to establish a connection, and in the absolute worst case, will log
> my own error message and tell the user.
>
> That way, if things go wrong, I at least have some idea where and how.
>
> In the same way, every discrete transaction (DB operation) takes place
> within a "try .. except" loop, and any problems are similarly caught.
>
> Saved my ass many times, that has ... :-)
>
> Regards
>
> Tim
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>