Hi !!!

> -----Original Message-----
> From: Ing. Gustavo Edelstein [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 25, 2001 1:24 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Insert records in a VB5 recordset
>
>
>
> Dear members,
>
> I'm new to MySQL and I'm using MyODBC. I can connect to my MySQL localhost
> from a VB5 appusing MyODBC. I can open a recordset (using RDO) and when I
> try to add a new record I got the following error msg:
>
> Run-time error 40069
> Client Cursor: 40 - Assigned data exceeds defined column size.
>
> The value has 4 chars long and the database field is 10 chars
> long. In this
> table I have a primary key defined and a timestamp field.
>
> Any help ?

Yes, this is because of invalid( accurately, the attributes that are not
supported by the driver) result set properties set by the application, is it
possible for you to send the code snippet that opens the rs with all
properties ?

Also, verify the results by toggling  "Don't optimize column width" option
in the DSN setup.

Regards, venu
--
For technical support contracts, go to https://order.mysql.com
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /  Mr. Venu <mailto:[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/ California, USA
       <___/ www.mysql.com



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

Reply via email to