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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php