Using Access 7 ODBC and Delpi 2:

I'm getting this error message from ODBC when I clear the
contents of a field and post the record. It updates an unchanged
zero-length field ok, but if I put something in the field, post
it, edit again and try and save a zero-length value, I get this
error.

It's not the same as the 'not null' error and the field doesn't
have 'not null'.

Any ideas anyone ?

--------------------------------------------------------------------
Mike Wilson                                      m...@oasis.icl.co.uk
SNI Medical Portfolio,  9-15 Blagrave Street,  Reading,  RG1 1PJ, UK
At home:         m...@plexus.demon.co.uk      http://www.hway.com/mrw

 -=> Quoting Mike Wilson <=-

 MW>  @FROM   :m...@oasis.icl.co.uk                                        
 MW> N  @SUBJECT:'Field cannot be zero length' error                        
 MW> N  @UMSGID :<4qlods$...@ozz.oasis.icl.co.uk>                          
 MW> N  @UNEWSGR:01comp.lang.pascal.delphi.databases                        
 MW> N Newsgroups: comp.lang.pascal.delphi.databases
 MW> Organization: ICL, Bracknell, UK
 MW> Message-ID: <4qlods$...@ozz.oasis.icl.co.uk>

 MW> Using Access 7 ODBC and Delpi 2:

 MW> I'm getting this error message from ODBC when I clear the
 MW> contents of a field and post the record. It updates an unchanged
 MW> zero-length field ok, but if I put something in the field, post
 MW> it, edit again and try and save a zero-length value, I get this
 MW> error.

I have exactly the same problem with Delphi 1 and an Access 2.0 table.
Have you noticed the "Allow null text fields" (or similar, don't know what
the message would be in the English versions) setting in Access? It should
help. (I'm not exactly sure, as I'm not the one to update the table
formats, and also, I'm on weekend-holiday :-)

The funny thing is that I only get the error if I edit the table. If I
insert a new record with null fields, everything is OK. Strange
indeed.

Regards,

Jani

--
---------------------------------------------------------------------
Jani Jarvinen, Helsinki Finland          jani.jrvi...@hiway.fipnet.fi

Check out Help Editor 2.0 for Windows at:
ftp://ftp.mpoli.fi/metropoli/windows/utils/hlped20.zip

1996: Only four years to computer confusion!
What have you done to avoid it?
---------------------------------------------------------------------

___ Blue Wave/QWK v2.12