lizheyang writes:
> Hello:
>
> I have a problem on update a table in VB.
> My environment is :
>
> Client :VB+myodbc in win98
> Server :mysql in Linux
>
> I have correctly setup the connection between client and server.And can
> do other sql .But when i want to execute the update :
>
> UPDAE news set tag=3 where news_id=2889
>
> This sql can execute in the server-side, but in VB program it can not
> execute and make a error.I have setup up a primary key in the news
> table.
>
> How can i do!!!!
>
> Thanks for your help.
>
>
> lizheyang
>
Hello,
Can you please give a little more information,
for example:
- What error message do you get from the VB program, _exactly_?
- Can you show us piece of your code, including this query?
- Can you show us how mysql -monitor handles the query, i.e.
do you get any error from it? The above:
"UPDAE news set tag=3 where news_id=2889"
Will certainly give you a parse error.
- Please include information of your table with
mysqldump --no-data databasename tablename > filename
and include the 'filename' in a mail. If you don't have
much data in your table, then you can leave option --no-data away.
Please send with mysqlbug and see section 'How to report bugs or
problems' from the manual for more information.
Regards,
- Jani
--
+-------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen |
| /*/ /*/ /*/ \*\_ |*| |*||*| jani@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+-------------------------------------------------------------+
