Whats your INSERT statement look like? And does it give any errors back?
-Nick
> I am
using MySql with Visual Basic.
>
> I Got an ERROR when trying to add a new record in
situation as under.
>
> I have a table Company
> and a field in that table EmpName char
(20)
> and one record is there value is = "Piyush"
> I am trying to add a new record I can add
if
the value of field is
> less then or equal to the length of old record len("Piyush") =
6.(Max
> Length of value from old records)
>
> If i will try to add "Ashok" i can add it
BUT
> If I
TRY TO ADD "SANDEEP" the length is 7 I could not add it.
> getting an error.
>
> and if there
is not any record means maximum value from old record is
> zero then i could
not add a record
means clearly i could not add FIRST
> RECORD ANYWAY FORM VISUAL BASIC.
>
>
>
> what is
solution
>
> Please help ME. Thanks in Advance
>
> - Piyush
>
>
>
> ---------------------------------------------------------------------
> 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 <mysql-
[EMAIL PROTECTED]> To
> unsubscribe, e-mail
> <mysql-
unsubscribe-
[EMAIL PROTECTED]> Trouble
> unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
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
