Adding a non-nullable TEXT field

[jda]

Thanks for the answer, Ivan.

Jon

> 
> On Aug 13, 2014, at 15:56, jda <jda at his.com> wrote:
> 
>> Hi,
>> 
>> I’m using this code to add a TEXT field to an existing table
>> 
>>      ALTER TABLE table1 ADD newField text DEFAULT '' NOT NULL
>> 
>> However, the field that is edited is nullable. How do I add a non-nullable field?
>> 
> 
> 
> For now any Valentina's TEXT field is nullable. You can not make it not-null (your "not null" was ignored.).
> We just thought it is no reason to have not-nullable text/blob/picture fields. Internally, empty data takes one blob-segment but null-data takes zero segments. On the other hand "not null" is sort of constraint which can be required by your business logic. Probably we have to allow not-nullable BLOBs...
> 
> -- 
> Best regards,
> Ivan Smahin
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20140813/8f25c711/attachment-0001.html>