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
________________________________________________________
No trees were killed in the sending of this message. However a large
number of electrons were temporarily inconvenienced.
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>
_______________________________________________
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>
|