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


> 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/

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