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
 Tags
Subject: CA Error with MYSql
Thread ID: 373605 Message ID: 373605 # Views: 57 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Sunday, March 24, 2013 5:06:44 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

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