How to INSERT or UPDATE with empty string

[Gina]

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

 

[Guest]

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]

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

 

[Guest]

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