Hi,

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
>>way.

> 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. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)