Benoît Minisini wrote:
>
>> > what I mention is also happen when you using the database manager to
>> > create the table and the default value . this happen if the field type
>> > is string . create a table (sqlite) using database manager . create a
>> > field type string . enter the default v
> > what I mention is also happen when you using the database manager to
> > create the table and the default value . this happen if the field type
> > is string . create a table (sqlite) using database manager . create a
> > field type string . enter the default value 'O' .save . refresh /reload
>
> what I mention is also happen when you using the database manager to create
> the table and the default value . this happen if the field type is string
> . create a table (sqlite) using database manager . create a field type
> string . enter the default value 'O' .save . refresh /reload . the
Benoît Minisini wrote:
>
>> 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 sho
> 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
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--->
Hi,
If you have defined a field type string lenght say 32.
And you click on the length cell and fill in 256, you get an error "The
lenght must be greater than 1 and lower than 255"
Thats fine, but you end up in a loop where you can't get out to correct
your mistake.
Regards,
Ron.
---
