Article View: borland.public.cppbuilder.database.multi-tier
Article #212Posting a record raises an exception wnen I enter a Zero Length String in a field
From: Robert Wheadon
Date: Fri, 18 Jun 2004 01:39
Date: Fri, 18 Jun 2004 01:39
17 lines
1458 bytes
1458 bytes
Hello,
I am making a program which reads and writes data from an Access 97
database. There are some a couple of string fields that my program reads
and writes to. These fields update properly when I enter a non-zero length
string into them. When I enter a zero length string in one of them and call
TTable::Post(), I get a EDBEngineError exception. The error message reads:
General SQL error.
Field 'Terminal.TermShortDescription' can't be a zero-length string.
Table
Any ideas about why this is happening?
Thanks,
Robert Wheadon
Technical Details
Message-ID:
<40d24794$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!fr.ip.ndsoftware.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,101d41f07aa51728,start X-Google-Attributes: gidfcd2b,public From: "Robert Wheadon" <robert.wheadon@monitorbm.co.nz> Newsgroups: borland.public.cppbuilder.database.multi-tier Subject: Posting a record raises an exception wnen I enter a Zero Length String in a field Date: Fri, 18 Jun 2004 13:39:26 +1200 Lines: 19 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4922.1500 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4925.2800 NNTP-Posting-Host: 203.167.201.38 Message-ID: <40d24794$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1087522708 203.167.201.38 (17 Jun 2004 18:38:28 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!fr.ip.ndsoftware.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail