INFO: the best size of VarChar in 2.0

[Claudius Sailer]

Am 04. Mrz 2005 um 21:29 Uhr schrieb Ruslan Zasukhin:

>> What do I have to do to convert from 504 to 1022?
>
> Actually 504 bytes is no bad. And you can continue to use it.
> Although for UTF16 this means 256 chars.
>
> Length of field can be changed
>
>     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....

thanks

Claudius