Subject Re: [firebird-support] Digest Number 1586
Author Anand

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

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

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

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

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


Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!