[Gambas-user] Database problem.

[Benoit Minisini]

On samedi 29 décembre 2007, R. Stormo wrote:
> Benoit Minisini wrote:
> > On jeudi 27 décembre 2007, R. Stormo wrote:
> >> I'm running SQLite3 and trying to create a view from a table.
> >> First time it says no records (should be) Second time I run give me an
> >> error.
> >> This is what I'm doing.
> >> Open my database in the database manager , double click on my table, all
> >> is
> >> ok upto now.
> >> Select SQL
> >> insert this
> >> create view test1 as select kontakt from faktura where kontakt='some
> >> name that exist';
> >> return "no records"
> >> Seconds time I try it give me
> >> "Cannot exec request
> >> Query failed: SQL error or missing database"
> >>
> >> First time it should give me records. Why does it not show views if they
> >> are created?
> >>
> >> Regards Rohnny
> >>
> >>
> >> My Gambas Community http://gambasforum.tk
> >
> > Can you tell what requests you wrote exactly?
> >
> > --
> > Benoit Minisini
>
> All described in previous message.
>
> create view test1 as select field_in_database from database_name where
> field_in_database='some name that exist';
>
>
> return "no records"
>  Seconds time I try it give me
> "Cannot exec request
> Query failed: SQL error or missing database"
>
> First time when it returned no records. It should have return records. The
> view did not show up as a table that would be nice if it did.
>
>
> Regards Rohnny
>
> My Gambas Community http://gambasforum.tk

If you create twice the same view, it is logical that you get an error the 
second time, isn't it?

-- 
Benoit Minisini