documentation -- CREATE TABLE

[Michael Lee]

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.


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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina