Subject | Re: [firebird-support] Re: Creating a view |
---|---|
Author | Daniel Rail |
Post date | 2003-07-07T15:15:07Z |
Hi Helen,
At July 7, 2003, 09:21, Helen Borrie wrote:
caption of the button is "Compile"(this is probably where the word
compiling comes from). QuickDesk runs the "CREATE VIEW" script when
the user clicks on the "Compile" button. But, the user has to commit
if Firebird or Interbase didn't return any errors, after executing(but
not committing) the script on the server. This way a person can still
rollback changes(for whatever reason) after the DDL has been executed.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
At July 7, 2003, 09:21, Helen Borrie wrote:
> Here's maybe what's happening - I don't have IBExpert, so I can onlyIf IB Expert uses the same names in the hints as QuickDesk, then the
> guess. He is using some tool for writing/editing scripts, without
> understanding that you actually have to RUN a script in order to create the
> objects in the database...It's odd that he's referring to "compiling a
> view", too, since you don't compile views.
caption of the button is "Compile"(this is probably where the word
compiling comes from). QuickDesk runs the "CREATE VIEW" script when
the user clicks on the "Compile" button. But, the user has to commit
if Firebird or Interbase didn't return any errors, after executing(but
not committing) the script on the server. This way a person can still
rollback changes(for whatever reason) after the DDL has been executed.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)