Mailing List Archive


Back to the month index Back to the list index
Joao Marcos Melo Mendes (jmmm@megamedia.pt)
Tue, 17 Sep 1996 17:56:16 +0100 (BST) 

Date: Tue, 17 Sep 1996 17:56:16 +0100 (BST)
From: Joao Marcos Melo Mendes <jmmm@megamedia.pt>
Subject: Re: [mSQL] Auto primary key generator patch
Message-Id: <Pine.BSF.3.91.960917175403.13643A-100000@gatekeeper.megamedia.pt>

Hey, there.:)

On Tue, 17 Sep 1996, Mike Black wrote:

> At 11:57 AM 9/16/96 -0600, you wrote:

> >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.

Hmmm... The docs say defining a key as a field generates an implicit 'not
null'. You can't not specify a 'not null' on the key defs.
Unless of course the patch in question also changes that...

                                        Joao Mendes
                                        MegaMedia, S.A.

"We're fools to make war on our brothers in arms." - Mark Knopfler

--------------------------------------------------------------------------
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!