At 11:15 22/02/2001 +0800, edith wrote:
Hi,
Other Microsoft products like Access doesn't permit the edition
of MySQL tables without a primary key on the table. If this is
your case, try to add a primary key on the MySQL table.
Regards,
Miguel
>Dear Sir/Madam,
> I'm a Visual FoxPro programmer. I want to use MySQL database for my
> programs. However, I cannot update MySQL database with my Visual FoxPro
> programs through ODBC (but I can view the record of table). My commands
> are as follow:
> CREATE CONNECTION conn1 DATASOURCE "MySQL" USERID "users" DATABASE
> "tempdata"
> STORE SQLSTRINGCONNECT('dsn=MySQL; uid=root; pwd=') TO
> xConnHandle //return of 'xConnHandle' is positive that means
> connection is successful//
> =SQLSETPROP(xConnHandle,'Transactions',2) //this return is
> negative that means there is an error on connection level//
>I don't know why I can view the table but I cannot update the table
>through ODBC. Would you help me to solve this problem? Thank you!
>Regards,
>Edith
__ ___ ________ __
/ |/ /_ __/ __/ __ \/ / http://www.mysql.com/
/ /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano <[EMAIL PROTECTED]>
/_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil
<___/ Development Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php