*****************
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)
***************

Actually, with IBExpert, after I construct the view definition,
I can click the 'Compile' button to compile it, but after that
there's no 'Commit' allowed. The 'Commit' button is disabled.
That was the problem I faced. This doesn't happen with a table,
however. When I construct a table, I can compile its definition
and then 'Commit' it. Since I couldn't do it with a View, I was
confused. But I finally located the SQL Editor in one of the
menu options, and used it to execute and then 'Commit' the View
definition.

Anand


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com