On 11 Oct 2001, at 22:17, Helen Borrie wrote:

> At 01:41 PM 11-10-01 +0200, you wrote:
> >At 12:24 2001-10-11 +0100, you wrote:
> >
> >
> > > > This is one of the main reasons why we will probably swutch to
> > > > another database, e.g. SQL Server, etc. It will be a great pity,
> > > > because I really like IB and the projects I have done on it run
> > > > beautifully...
> > >
> > >1. I don't think SQL Server will allow you to do metadata changes
> > >on fly, but please correct me if I am wrong. Certainly Sybase
> > >didn't.
> >
> >I am not 100% sure myself, but my wife works with it and says it can.
> >Still need to investigate though...
>
> Sure, SQL Server stored procedures are COOL. As long as they
> syntax-check OK, they get written out in interpreter code and the next
> user can invoke them straight away. They get precompiled
> "just-in-time" and any data integrity or validation errors and logic
> bugs will present themselves to the user for "in-line QA".

Yeah right, you know exactly what will happen, some idiot user at
3:00am on Christmas day, the only morron in the entire organization
working that day, will find that SP, and get on the phone ...

Paul

Paul Schmidt,
Tricat Technologies
Email: paul@...
Website: www.tricattechnologies.com