Subject Re: [firebird-support] Re: Creating a view
Author Daniel Rail

At July 5, 2003, 07:26, Helen Borrie wrote:

> At 10:09 AM 5/07/2003 +0000, you wrote:
>>Oops! I didn't want to know how to 'write' a view, but I merely want
>>to know how a view I have written can be saved in a Firebird database
>>using IBExpert.
>>As I said, presently IBExpert only allows me to save the view
>>definition to a text file with the extension of SQL, while I want to
>>know how it can be saved inside the database, just like the normal

> CREATE VIEW is an SQL statement. So you don't *save* it, you commit it!

Disregard, what I just posted. I understand the question now. You
are right Helen, I think the only step he's missing is to COMMIT the
view. And, when he sees the compile was successful, he should be
seeing the COMMIT button on that form.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (