Re: How to INSERT or UPDATE with empty string

Tech-Archive recommends: Fix windows errors by optimizing your registry

Believe me, I only know it from bitter experience myself. ;)

"Gina" wrote:

> Hi ... thanks for reminding me on 'put at least a value into the PK field'
> ;-)
>
> yes .... just checked field2 was not allowed to contain empty value or so
> :))
> and the query now works even with an empty field2
> thanks a lot ... such an easy solution!!!!
>
> Gina
>
>
> "MDW" <MDW@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
> news:592B07B0-B245-425A-8E00-03F386D03D05@xxxxxxxxxxxxxxxx
> > Obviously, your PK field cannot contain a null value.
> >
> > Now (I only ask this because my former boss was notorious for missng this)
> > are you sure that in the design of your table, Field2 is set to "Allow
> Zero
> > Length"?
> >
> > "Gina" wrote:
> >
> > > Hi.
> > >
> > > my queries work (more or less satisfyingly)
> > > ..... 3 fields: (PK)text, text, currency
> > >
> > > I have exported them to a text file where the fields are separeated by a
> > > vbTab
> > > on the import all works well ...
> > > but if field2 has a null value or empty string the currency field3 does
> not
> > > get updated ....
> > >
> > > If field2 = "" Or IsNull(field2 ) Then field2 = field1
> > > this way it works, field3 gets updated .... but is it not possible to
> update
> > > a record with an empty value in one or more fields ....
> > >
> > > Thanks,
> > > Gina
> > >
> > >
> > >
>
>
>
.