Your 3 DREAM FEATURE for Vstudio ?

[Ruslan Zasukhin]

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]