Tom,
That does sound very weird!
Do you have any third party tools like EMS MyManager to just view data
and do test queries? What happens when you do 'SELECT * from stores'? Do
you still get the same error.
If you care to send me a SQL Dump I can install the DB and take a look
as a different pair of eyes.
HTH
Tom
> Right... mostly because this table is not designed to be
> added to outside of development...
>
> I tried what you said anyway just for kicks, but still no go.
> Remeber this is a SELECT statement, and a very simple one,
> that is causing the error.
>
> Just can't wrap my head around this.. v. weird
>
> Cheers,
> Tom
>
> On 31/05/2005, at 12:28 AM, Dixon, Tom wrote:
>
> > 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>
|