RE: [DUG]: embedded database.

[Paul Ritchie]

> It's a right pain to have to handle this as a special case 
> (using SP's etc to solve).

Maybe this points towards the real problem, that SPs are perceived to be a
pain?  We use Visual Studio to edit and debug stored procedures on a SQL
Server 7 database and it is very simple, with code highlighting, and
tooltip-style variable inspection.

I have heard the argument that all updates to a database should be done
through stored procedures to easily ensure consistency (for a complex
operation) and enhance security as users no longer need permissions to
update tables directly.


Paul Ritchie
Radio Computing Services.

---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"