Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: prasanna kunder
  Where is prasanna kunder?
 mumbai
 India
 prasanna kunder
 Tags
Subject: RE: CA Error with MYSql
Thread ID: 373605 Message ID: 373707 # Views: 46 # Ratings: 2
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Monday, March 25, 2013 4:59:46 PM         
   


> >
> > You should keep a single thread for all your CA problems.
> >
> > Maybe you should update the table structure if possible. My PKs are all named ID.
> >
> > Regards
> > Tushar
> > http://weblogs.foxite.com/tushar/
>
> problem is that my Field in MySql Table is IdCustomer_Detail ie. total 17character
>
> it's accept in MySql , but when cursor in vfp it's only take 10 digit character
>
> so now i am keeping only 10digit character field name

The 10-char column name restriction only applkies to free DBF tables. Cursors can have column names over 100 chars long, as can DBC database tables.

-Anders

ENTIRE THREAD

CA Error with MYSql Posted by prasanna kunder @ 3/24/2013 5:06:44 AM
RE: CA Error with MYSql Posted by tushar @ 3/24/2013 5:30:33 AM
RE: CA Error with MYSql Posted by prasanna kunder @ 3/24/2013 5:56:46 PM
RE: CA Error with MYSql Posted by Anders Altberg @ 3/25/2013 4:59:46 PM
RE: CA Error with MYSql Posted by prasanna kunder @ 3/26/2013 8:47:54 AM
RE: CA Error with MYSql Posted by Tore Bleken @ 3/26/2013 9:03:20 AM
RE: CA Error with MYSql Posted by Tore Bleken @ 3/25/2013 5:07:30 PM
RE: CA Error with MYSql Posted by prasanna kunder @ 3/26/2013 8:51:48 AM
RE: CA Error with MYSql Posted by Tore Bleken @ 3/26/2013 9:05:47 AM