how will i increase the size of column in database table

Login to reply to this topic.
Thu, 2005-12-22 14:12
jai
Joined: 2005-01-22
 Forum posts: 112
hi i m increasing the size of column in Database table the code is:
///
          iLength=2000;
TDbCol Note (KUserName,EDbColText,iLength);
/////
but size is not increasing,i takes only 50 character. . i heve also used KDbUndefinedLength ,but it takes only 140 character
so pls tell me how will i increase the size of column.

thanks with reagards       

Sat, 2005-12-24 23:45
ro0p-forum
Joined: 2005-06-04
 Forum posts: 131
Re: how will i increase the size of column in database table
Hi,
Max length of EDbColText is 255 char!!!
Use EDbColLongText. This way of database handling is not my own, so I dont know how to change the column type, but with SQL you can use ALTER TABLE statement. You can change anything in table structure whit it. See SQL documentation.
Use: iDatabase.Execute(_L("ALTER TABLE ..."));

Merry Xmas!

Ro0p
 
  • Login to reply to this topic.