pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedInserting NULL with pgaccess
5+ messages / 2 participants
[nested] [flat]
* Inserting NULL with pgaccess
@ 2000-04-19 07:54 Ivo Simicevic <ivo@ultra.hr>
0 siblings, 1 reply; 5+ messages in thread
From: Ivo Simicevic @ 2000-04-19 07:54 UTC (permalink / raw)
To: pgsql-interfaces
Using pgaccess:
Is there a way of getting field value back to NULL
once you have typed something into it?
Simply erasing with backspace doesn't change it
back and ESCape can't help, and you can't delete record as
it has no oid, yet.
Regards,
Ivo.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Inserting NULL with pgaccess
@ 2000-04-19 16:05 Ken J. Wright <ken@ori-ind.com>
parent: Ivo Simicevic <ivo@ultra.hr>
0 siblings, 1 reply; 5+ messages in thread
From: Ken J. Wright @ 2000-04-19 16:05 UTC (permalink / raw)
To: Ivo Simicevic <ivo@ultra.hr>; pgsql-interfaces
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Inserting NULL with pgaccess
@ 2000-04-20 07:24 Ivo Simicevic <ivo@ultra.hr>
parent: Ken J. Wright <ken@ori-ind.com>
0 siblings, 1 reply; 5+ messages in thread
From: Ivo Simicevic @ 2000-04-20 07:24 UTC (permalink / raw)
To: Ken J. Wright <ken@ori-ind.com>; +Cc: pgsql-interfaces
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Inserting NULL with pgaccess
@ 2000-04-20 14:31 Ken J. Wright <ken@ori-ind.com>
parent: Ivo Simicevic <ivo@ultra.hr>
0 siblings, 1 reply; 5+ messages in thread
From: Ken J. Wright @ 2000-04-20 14:31 UTC (permalink / raw)
To: Ivo Simicevic <ivo@ultra.hr>; Ken J. Wright <ken@ori-ind.com>; +Cc: pgsql-interfaces
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Inserting NULL with pgaccess
@ 2000-04-20 16:20 Ken J. Wright <ken@ori-ind.com>
parent: Ken J. Wright <ken@ori-ind.com>
0 siblings, 0 replies; 5+ messages in thread
From: Ken J. Wright @ 2000-04-20 16:20 UTC (permalink / raw)
To: Ivo Simicevic <ivo@ultra.hr>; +Cc: pgsql-interfaces
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2000-04-20 16:20 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-04-19 07:54 Inserting NULL with pgaccess Ivo Simicevic <ivo@ultra.hr>
2000-04-19 16:05 ` Ken J. Wright <ken@ori-ind.com>
2000-04-20 07:24 ` Ivo Simicevic <ivo@ultra.hr>
2000-04-20 14:31 ` Ken J. Wright <ken@ori-ind.com>
2000-04-20 16:20 ` Ken J. Wright <ken@ori-ind.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox