Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: prasanna kunder
  Where is prasanna kunder?
 mumbai
 India
 prasanna kunder
 To: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 Tags
Subject: RE: CA Error with MYSql
Thread ID: 373605 Message ID: 373644 # Views: 45 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Sunday, March 24, 2013 5:56:46 PM         
   


> > what i pacing ,
> >
> > i did table in MySql
> > that is Customer_Detail
> > and keep main Field IdCustomer_Detail (Primary Key) and ...
> >
> > it's all ok
> >
> > but when i connect with CA to My MySql Table
> > it's show error on
> >
> > .KEYFIELDLIST = "IdCustomer_Detail"
> >
> > error is
> > Invalid Key Column Name "IdCustomer_Detail"
> >
> > if i keep
> > .KEYFIELDLIST = "IdCustomer"
> >
> > it's ok
> >
> > why it's happening , it's only accept 10 character
> > how i overcome from this , because myslq not prevent minimum character,
> > but VFP Do
> >
> >
> > thanks again
>
> 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

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