field cannot be zero length string

FTSoft

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

field cannot be zero length string

I am using ttable to access a MS access 97 database on a Novel server.
When editing a record, if the user clears a field ( deletes the data ) ,
then attempts to save the record, the program gets a 'general sql error
- field cannot be zero length string'. If you insert a new record,
fields can be null, why not in update?

Can I trap this, and fix it?

Terry

FTSof

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:field cannot be zero length string

Well, I found the solution. Being a new user of Access 97... I changed the
field property 'Allow Zero Length' to YES and the problem was fixed.

Quote

FTSoft wrote:
> I am using ttable to access a MS access 97 database on a Novel server.
> When editing a record, if the user clears a field ( deletes the data ) ,
> then attempts to save the record, the program gets a 'general sql error
> - field cannot be zero length string'. If you insert a new record,
> fields can be null, why not in update?

> Can I trap this, and fix it?

> Terry

Other Threads

1. Field cannot be a 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??