Board index » delphi » Zero length String Error

Zero length String Error

I get the following error message:

        General SQL error
        Field 'FieldName' cannot be a zero length string.
        Table.

when I:

        Add some value to a string field
        Post the record
        Remove the value I entered by backspacing
        Attempt to repost the record.

I am using D4 with Access 97.    The required property is not set to
required either in Delphi or Access.

Any suggestions would be appreciated.

Anthony Magauran

 

Re:Zero length String Error


There is a property for string fields in Access that controls whether zero
length strings are allowed in addition to the required property. Set Allow
Zero Length Strings to true in the table definition in Access.

--
Bill

Bill Todd (TeamB)
(TeamB cannot respond to questions received via email)

Other Threads