Mailing List Archive


Back to the month index Back to the list index
Daniel E. White (igor@barsoom.digex.net)
Tue, 17 Sep 1996 11:02:31 -0400 (EDT) 

From: "Daniel E. White" <igor@barsoom.digex.net>
Message-Id: <199609171502.LAA17427@barsoom.digex.net>
Subject: Re: [mSQL] Auto primary key generator patch
Date: Tue, 17 Sep 1996 11:02:31 -0400 (EDT)

>
> At 11:57 AM 9/16/96 -0600, you wrote:
> >Hello All!
> >
> >
> >this may be a stupid question, but I tried to read from the instructions
> >supplied with the patch but could not find any info on how to Call Apon
> >this auto key patch.
> >
>
> I think your problem may be that you need to give the insert call a NULL
> parameter instead of nothing at all for the key. Also, ensure you didn't
> specify "NOT NULL" on the key definition. A dump of your table and your
> insert call would be helpful.
> -

I believe this to be impossible.

>From the mSQL Documentation:
"Defining a field as a key generates and implicit "not null" attribute
for the field."

Anyway, I fail to see the use of a NULL key field. 

-- 
------------------------------------------------------------------------
                                                               Dan White
------------------------------------------------------------------------
"Sometimes  I  think  the  surest  sign  that  intelligent  life exists
 elsewhere  in the universe is that none of it has tried to contact us."
                                                  Calvin (Bill Waterson)
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com.  Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!