Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 To: prasanna kunder
  Where is prasanna kunder?
 mumbai
 India
 prasanna kunder
 Tags
Subject: RE: MySql Error
Thread ID: 393963 Message ID: 393979 # Views: 29 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, December 27, 2013 11:14:59 AM         
   


> >
> >
> > Yes, the error code is important.
> > Looks as if you can either truncate values longer than Len(10) manually, Update quotation Set AccCode = Left(AccCode, 10),
> > or turn the MySQL server "sql_mode" to something that is not "strict":
> > http://www.heidisql.com/forum.php?t=5205
> > http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
> >
> >
> >
> > hth
> > -Stefan
>
> thanks lots ,
> alter table not apply reason is Field AccCode have total 50 character including space
> i ignore space
> that's why Alter Table command show error
> Error Code: 1265. Data truncated for column 'AccCode' at row 1
>
> as per your valuable suggestion
>
> first i updated the table
> like this
> update maxell_data.quotation set acccode = left(acccode,10);
> then i try alter table
> it's work
>
> thanks, thanks again for your valuable time



You are welcome!



-Stefan

ENTIRE THREAD

MySql Error Posted by prasanna kunder @ 12/27/2013 9:21:28 AM
RE: MySql Error Posted by Stefan Wuebbe @ 12/27/2013 9:57:55 AM
RE: MySql Error Posted by prasanna kunder @ 12/27/2013 10:02:01 AM
RE: MySql Error Posted by David Mustakim @ 12/27/2013 10:11:40 AM
RE: MySql Error Posted by prasanna kunder @ 12/27/2013 10:18:11 AM
RE: MySql Error Posted by David Mustakim @ 12/27/2013 10:23:42 AM
RE: MySql Error Posted by prasanna kunder @ 12/27/2013 10:32:18 AM
RE: MySql Error Posted by David Mustakim @ 12/27/2013 10:38:25 AM
RE: MySql Error Posted by prasanna kunder @ 12/27/2013 10:46:50 AM
RE: MySql Error Posted by prasanna kunder @ 12/27/2013 10:06:52 AM
RE: MySql Error Posted by Stefan Wuebbe @ 12/27/2013 10:32:42 AM
RE: MySql Error Posted by prasanna kunder @ 12/27/2013 10:45:23 AM
RE: MySql Error Posted by Stefan Wuebbe @ 12/27/2013 11:14:59 AM