Received: from cncware.whidbey.com (IDENT:ken@cncware.whidbey.com [209.166.83.37]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA72813 for ; Thu, 20 Apr 2000 12:22:48 -0400 (EDT) (envelope-from ken@cncware.whidbey.com) Received: from localhost (localhost [[UNIX: localhost]]) by cncware.whidbey.com (8.9.3/8.9.3) id JAA11506; Thu, 20 Apr 2000 09:23:49 -0700 From: "Ken J. Wright" Reply-To: "Ken J. Wright" Organization: Cncware To: Ivo Simicevic Subject: Re: Inserting NULL with pgaccess Date: Thu, 20 Apr 2000 09:20:08 -0700 X-Mailer: KMail [version 1.0.20] Content-Type: text/plain Cc: pgsql-interfaces@postgreSQL.org References: <00042007335402.11122@cncware.whidbey.com> MIME-Version: 1.0 Message-Id: <00042009234806.11122@cncware.whidbey.com> Content-Transfer-Encoding: 8bit X-Archive-Number: 200004/167 Well the changes were put in on 4/29/1999 and it works fine for me. It will however fail as you described if you included the quote marks. On Thu, 20 Apr 2000, Ken J. Wright wrote: > Hmmm.... This was a patch I submitted long ago to Contantin. I guess it fell > through a crack. I'll dig it up for you. > > Ken > > On Thu, 20 Apr 2000, Ivo Simicevic wrote: > > On Wed, Apr 19, 2000 at 09:05:53AM -0700, Ken J. Wright wrote: > > > On Wed, 19 Apr 2000, Ivo Simicevic wrote: > > > > Using pgaccess: > > > > > > > > Is there a way of getting field value back to NULL > > > > once you have typed something into it? > > > > > > Type the word "null" in the field. > > > > > > Cheers! > > > > > > Ken > > > > Being curious enough I have followed your instruction even > > though it raises new questions like "how you enter word null as > > data..." :-)) and guess what - I got an error "bad date > > external representation 'null' " (of course). > > > > Next one please. :-)) > > > > Ivo.