Field cannot be a zero-length string

Anabella Giseour

Delphi Developer

Sat, 25 Dec 2004 03:58:41 GMT

Field cannot be a zero-length string

I'm using TADODataSet, provider and ClientDataSet with Access database.
When I delete data in some fields I get a message Field 'Field_Name' cannot
be a zero-length string.
Fields in Access database have property Allow zero length set to No which is
default value.
The interesting thing is that I get this message for some fields and for
some I don't.
All field have this property set to No.
Any ideas?
Thanks in advance for your help!

Best wishes, Anabella

D. Rieme

Delphi Developer

Sun, 26 Dec 2004 00:02:25 GMT

Re:Field cannot be a zero-length string

I think the error only comes up on text-based fields (string, memo), no
problem with number-fields.

Dirk

Quote

"Anabella Giseour" <gisanabe...@yahoo.com> wrote in message

news:3d29eef4_1@dnews...

Quote

> I'm using TADODataSet, provider and ClientDataSet with Access database.
> When I delete data in some fields I get a message Field 'Field_Name'
cannot
> be a zero-length string.
> Fields in Access database have property Allow zero length set to No which
is
> default value.
> The interesting thing is that I get this message for some fields and for
> some I don't.
> All field have this property set to No.
> Any ideas?
> Thanks in advance for your help!

> Best wishes, Anabella

Anabella Giseou

Delphi Developer

Sun, 26 Dec 2004 02:53:40 GMT

Re:Field cannot be a zero-length string

Of course. All fields I mentioned are text-based (string).

Anabella

Quote

"D. Riemer" <Dirk.Rie...@cgey.com> wrote in message

news:3d2b09a8$1_2@dnews...

Quote

> I think the error only comes up on text-based fields (string, memo), no
> problem with number-fields.

> Dirk

> "Anabella Giseour" <gisanabe...@yahoo.com> wrote in message
> news:3d29eef4_1@dnews...
> > I'm using TADODataSet, provider and ClientDataSet with Access database.
> > When I delete data in some fields I get a message Field 'Field_Name'
> cannot
> > be a zero-length string.
> > Fields in Access database have property Allow zero length set to No
which
> is
> > default value.
> > The interesting thing is that I get this message for some fields and for
> > some I don't.
> > All field have this property set to No.
> > Any ideas?
> > Thanks in advance for your help!

> > Best wishes, Anabella

DRS

Delphi Developer

Sun, 26 Dec 2004 03:18:43 GMT

Re:Field cannot be a zero-length string

Quote

"Anabella Giseour" <gisanabe...@yahoo.com> wrote in message

news:3d2b3134_1@dnews...

Quote

> Of course. All fields I mentioned are text-based (string).

Nulls and zero-length strings are not identical in Access, so if some of
your text fields were null and some contained zero-length strings that would
explain why some fields trigger the rule and some don't.

Quidquid latine dictum sit, altum videtur.

Other Threads

1. field cannot be zero length string

2. 'Field cannot be zero length' error

3. Access error: field cannot be a zero-lenght string

4. SQL Server 7 string field lengths >255 length

5. TClientSocket and zero-length SendText strings

6. zero-length strings

7. Zero-length string in predicate causes TADOQuery to blow

8. Zero length string error

9. Zero-length string

10. Help- SQL7 to Access 97 ZERO Length Strings??