sqlexp and CREATE VIEW

[markandirene]

Hello

I have created a view using sqlexp:

create view marky as select company, name, location from pub.corporation, pub.docloc where ident = company;

and can successfully use this view.

However, when I close down and restart sqlexp, the view has gone. Why? Do views only last for the lifetime of a session?

Thanks

Mark

 

[StefGay]

HI,

have you "commited" your create view ? The default parameter for auto commit is false into SQL Explorer.

Stéphane.