INFO: the best size of VarChar in 2.0

[Ruslan Zasukhin]

On 3/4/05 10:42 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

>> 
>>     Vstring.maxLength = xxx
> 
> Is it possible to use ALTER table?
> 
> My database Class looks
> 
>    name="Online"
>    Anbieter=new VVarChar("Anbieter",504,EVFlag.fUnique+EVFlag.fIndexed)
>    URL=new VVarChar("URL",504)
>    ErsteInfo=new VVarChar("ErsteInfo",504)
>    AnzahlTrennerEins=new VLong("AnzahlTrennerEins")
>    TrennerEins=new VVarChar("TrennerEins",504)
>    TrennerZwei=new VVarChar("TrennerZwei",504)
>    Sortierung=new VULong("Sortierung")
>    USNotation=new VBoolean("USNotation")
> 
> and I normally use Method
> 
>    cmd="ALTER TABLE Kategorien ADD Budget LONG"
>    count=tmpDB.SQLExecute(cmd)
> 
> to change tables....

Yes 2.0 support this in ALTER TABLE...
It is bad that we have not translate yet our new pages.

Please look into VSQL.pdf, grammar of VSQL.
Find section about ALTER table.

Exists now branch 
    
    change ..
and     
    modify


As for me, note, SQL way is much harder then API way for this task...


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------