| Subject | RE: [firebird-support] Re: Creating a view |
|---|---|
| Author | Alan McDonald |
| Post date | 2003-07-07T22:04:09Z |
Daniel,
yes - you compile but you get a dialog straight away showing either success
or failure of your code. At this point you have two choices if successful (a
commit button or a rollback button) and only one choice if failure
(rollback)
This is all in the "Create View" area.
You can also create a view by running the code in the SQL editor or also in
the SQL Script executive. In the script executive, the default is commit if
there are no errors. In the SQL editor, you run it and commit it manually,
if you do not commit then when you close the editor of IBExpert it asks you
to commit or rollback each transaction you started and have not yet
"completed"
In any case it's very hard not to do something after deciding what you need
todo.
Alan
yes - you compile but you get a dialog straight away showing either success
or failure of your code. At this point you have two choices if successful (a
commit button or a rollback button) and only one choice if failure
(rollback)
This is all in the "Create View" area.
You can also create a view by running the code in the SQL editor or also in
the SQL Script executive. In the script executive, the default is commit if
there are no errors. In the SQL editor, you run it and commit it manually,
if you do not commit then when you close the editor of IBExpert it asks you
to commit or rollback each transaction you started and have not yet
"completed"
In any case it's very hard not to do something after deciding what you need
todo.
Alan
> -----Original Message-----
> From: Daniel Rail [mailto:daniel@...]
> Sent: Tuesday, 8 July 2003 1:15 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Re: Creating a view
>
>
> Hi Helen,
>
> At July 7, 2003, 09:21, Helen Borrie wrote:
> > Here's maybe what's happening - I don't have IBExpert, so I can only
> > 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.
>
> If IB Expert uses the same names in the hints as QuickDesk, then the
> 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)
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>