[Gambas-user] Database problem.

[R. Stormo]

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
-- 
View this message in context: http://www.nabble.com/Database-problem.-tp14511016p14536101.html
Sent from the gambas-user mailing list archive at Nabble.com.