saving record to database issue

[codesearcher]

I have this regular way of saving record to the mysql database which is below:

rs.AddNew
rs.Fields("empid") = empid.Text 'save employee id integer type
rs.Fields("empfp") = FPBlob 'save finger print mediumblob type
rs.Update

However, when I do the code above, on the blob data is saved and the employeeid is not saved.
When, I remove the saving of empfp on that code, the employeeid can now be saved.

Which means, I cannot save both record on this code.

What should I do?

[Nightwalker83]

Is the database auto incrementing the records or are you assigning one manually for each record?

[codesearcher]

no its not incrementing

[goranvuc]

Have you tried (just in case of wrong conversion)?

rs.AddNew
rs.Fields("empid") = Val(empid.Text) 'save employee id integer type
rs.Fields("empfp") = FPBlob 'save finger print mediumblob type
rs.Update

Are you sure that BLOB field is saved?

BLOB data should go something like:

rs.AddNew
rs.Fields("empid") = Val(empid.Text) 

rs.Fields("empfp").AppendChunk Null
rs.Fields("empfp").AppendChunk FPBlob

rs.Update

[codesearcher]

the saving is ok if done individually but if done both, then only the blob is saved.