Mailing List Archive


Back to the month index Back to the list index
hillj@iscclink.is.qms.com
Tue, 17 Sep 96 08:34:07 CST 

From: hillj@iscclink.is.qms.com
Date: Tue, 17 Sep 96 08:34:07 CST
Message-Id: <9608178429.AA842974447@iscclink.is.qms.com>
Subject: Re[2]: [mSQL] Auto primary key generator patch

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

If you are using the same patch that I do, then yes, you must actually do the
INSERT with a "NULL" value for that field. Not a "" or a " " but N-U-L-L.

JGH-

-------------------------------------------------------------------------
   James Hill james_hill@mkt.qms.com
   Webmaster / Interactive Multimedia (334) 639-3274
   QMS, Inc. - Mobile, AL USA http://www.qms.com/
-------------------------------------------------------------------------
--------------------------------------------------------------------------
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!