Hmmm... Why would you want a table that allows one to insert a
completely Null record. If you change your record id "idstore" to
NotNull then this may fix your problem. You probably would want to set
it to AutoNumber also...
HTH
Tom
> 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
_______________________________________________
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>
|