[Gambas-user] Bug in Database manager

[kobolds]

gambas 2.14 
database sqlite

I create table with 2 datetime fields (start_date , end_date) and default
value current_timestamp . and 1 string field (stg_status) with default 'O'

when I open using gambas database manager
the 2 datetime field show , 
start_date --> default show --> 0
end_date---> default show --> 8980056

the string field stg_status --> default show --> 4.444578977261E-317

I also found very strange limitation in database manager . if you manual
create a table from sqlite konsole . if you type like this :
create table testtbl( std_id integer primary key autoincrement , std_name
text);

sqlite execute no problem but when you open using database manager , it give
error no primary key 

you must type
create table testtbl( 'std_id' INTEGER PRIMARY KEY AUTOINCREMENT ,
'std_name' TEXT);

why such weird limitation exist ? 

-- 
View this message in context: http://www.nabble.com/Bug-in-Database-manager-tp24358215p24358215.html
Sent from the gambas-user mailing list archive at Nabble.com.