Your 3 DREAM FEATURE for Vstudio ?

[Heinrich Ruoff]

id INTEGER NOT NULL DEFAULT 0, -> not working
id INTEGER DEFAULT 0 NOT NULL,  -> is working
shorttext text(512) -> is working
shorttext text(512) DEFAULT 'def' -> not working


On 6/21/05, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
> On 6/21/05 11:24 AM, "Heinrich Ruoff" <heinrichruoff at gmail.com> wrote:
> 
> > how can a field of type text be defined?
> > shorttext text(512), shorttext text,
> > both don't work?
> >
> > CREATE TABLE tb_test (
> >   id INTEGER NOT NULL,
> >   shorttext text(512),
> >   longtext text
> > );
> 
> Hmm,
> 
> blob_type
>     :   < FIXEDBINARY | VARBINARY> ( max_size )
>     |   <BLOB | PICTURE > ( segment_size )
>     |   TEXT ( segment_size )
> 
> So the form
> 
> CREATE TABLE tb_test (
>    id INTEGER NOT NULL,
>    shorttext text(512)
> );
> 
> Should work.
> 
> And yesterday Sergey have enable the second form also.
> 
> 
> Heinrich, btw, note, 512 this is not TOP LIMIT !!!
> For text field this is SEGMENT SIZE.
> 
> 
> --
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
> 
> [I feel the need: the need for speed]
> 
> 
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>