INFO: the best size of VarChar in 2.0

[Claudius Sailer]

Am 04. Mrz 2005 um 22:04 Uhr schrieb 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...

it would be a good thing when converting_1_2 supports functionality to 
transfer 504 to 1022. Reason? I don't want to have the problem after 
converting database that I lost datas.
I will write feature request? IMHO BugFix is a little bit hard ;-))

bye


Claudius