documentation -- CREATE TABLE

[Ruslan Zasukhin]

On 11/7/08 7:19 AM, "Michael Lee" <michaeljlee at comcast.net> wrote:

Hi Michael,

> There are other errors in this syntax besides String[12].   After
> some frustration and searching I found a note on this list saying the
> ordering of the CONSTRAINT, DELETE and UPDATE sections is incorrect.

Aha, yes I remember this issue now.

Btw, always its good keep bookmark on this page of
    Valentina SQL Grammar:

<http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:docume
ntation:vsql:reference:sqlgrammar>


This is the most up to date page, which strictly follow to grammar of our
SQL parser.

So lets go to section "Table Definition"

column_constraint
    :    [ CONSTRAINT IDENT ]
         {    NOT NULL
         |    NULL 
         |    INDEXED
         |    WORDS
         |    COMPRESSED
         |    TEMPORARY                                       (v4.0)
         |    { PRIMARY KEY | UNIQUE }
         |    { AUTOINCREMENT | AUTO_INCREMENT }
         |    IDENTITY
         |    CHECK ( search_condition )
         |    references_specification
         |    METHOD( STRING_LITERAL )
         } 

Really.  Rule CONSTRAINT  is BEFORE other field flags.

Fixing wiki page again.
Thank you for point!


> On Nov 6, 2008, at 2:02 PM, Ruslan Zasukhin wrote:
> 
>> On 11/6/08 9:01 PM, "Michael Lee" <michaeljlee at comcast.net> wrote:
>> 
>>> The syntax for CREATE TABLE at the following URL appears to be wrong:
>>> http://www.valentina-db.com/dokuwiki/doku.php?
>>> id=paradigma:public:en:documentation:vkernel:vlink:foreign_key
>> 
>> CREATE TABLE Phone(
>>     Number String[12],
>>     PersonPtr ULONG INDEXED REFERENCES Person(ID)
>>         ON DELETE SET NULL
>>         ON UPDATE SET NULL
>>         CONSTRAINT link_Person_Phone )
>> 
>> 
>> String[12]  ?
>> 
>> Yes should be ()   -- fixed

-- 
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]