I am creating a VB app that stores it's data in a MySQL database file. I was having trouble adding a new record as the system would not let me store my text information in the proper fields. For example I had a field title Customer_Name and for testing I had created the first record (using MySQLFront) with the field name for the record, (i.e. Field=Customer_Name; First-Record-Value=Customer_Name) that way I could verify everything was linked properly. Then when I tried to create a new record (i.e. Field=Customer_Name; New-Record-Value=Anaheim Steel Inc) I would get an error but if I kept the value of the new record to fewer characters than were in the first record (i.e. Customer_Name = 13 letters) then it saved fine. My field was defined as VarChar(50) and when I filled the first record with a 50 character entry I was then able to create new records up to the maximum.
Does anyone know why this would occurr? My current workaround is a dummy first record, but should someone delete that record my program will not function properly. I was able to save larger information using MySQLFront but not from my application.
Greg Hicks
Does anyone know why this would occurr? My current workaround is a dummy first record, but should someone delete that record my program will not function properly. I was able to save larger information using MySQLFront but not from my application.
Greg Hicks
