IsNull with MySQL

[Guest]

I migrated the backend of the MsAccess database to MySQL and is now testing
the front end to make sure that it works with the backend. I'm encountering
a problem on one of the fields (Field1) set with type=int(11), Null=yes,
Default=Null. Current form has a code of line to test whether Field 1 using
the IsNull() funtion in Access.

But when the recordset is empty, I'm getting an error (with MySQL) that said
there is not value for this field. What am I doing wrong?
Any pointers would be greatly appreciated. Thanks.

 

[Dirk Goldgar]

I migrated the backend of the MsAccess database to MySQL and is now
testing the front end to make sure that it works with the backend.
I'm encountering a problem on one of the fields (Field1) set with
type=int(11), Null=yes, Default=Null. Current form has a code of
line to test whether Field 1 using the IsNull() funtion in Access.

But when the recordset is empty, I'm getting an error (with MySQL)
that said there is not value for this field. What am I doing wrong?
Any pointers would be greatly appreciated. Thanks.

You're testing a control on the form with the IsNull() function? If it
fails when the form's recordset is empty, could it be that either the
form doesn't allow additions, or the form's recordset is not updatable,
so the form has no "new record"? If that's the case, I think you'd get
such an error referring to any control in the detail section.