I've dumped a fairly hefty mdb database into MySQL (4.0.20a ->
provided by hosting service) with some difficulty, however I'm having
a weird issue with one particular table.
the error is coming back as:
Invalid use of Null - Err.Number:94 - SQL:SELECT idCategoryStart FROM
stores WHERE idStore=1
stores is a VERY basic table, with the schema lifted straight over
from the MDB database.
It looks like this under MySQL:
`idStore` int(4) default NULL,
`storeDescription` varchar(50) default NULL,
`idCategoryStart` int(4) default NULL
and looks like this under JET / MDB
idStore integer(4) precision(10) may defer, unknown
updatable, fixed, may be NULL
storeDescription VarWChar(50) precision(255) may defer,
unknown updatable, can be set to NULL, may be NULL
idCategoryStart integer(4) precision(10) may defer, unknown
updatable, fixed, can be set to NULL, may be NULL
As far as I can tell, these two schema are directly equivalent
Both have the record
1 English 1
The query works fine under the MDB database, but I get the "invalid
use of NULL' under MySQL.
Help me, I'm going insane!
Cheers,
Tom
____________________________________________________
Programming is an art form that fights back.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|