DatabaseError Exception and BeforePost event

Article View: borland.public.cppbuilder.database.ado

Article #2706

Back to borland.public.cppbuilder.database.ado Previous Next

#2706

From: Wu JianHua
Date: Fri, 11 Apr 2003 08:18

16 lines
1535 bytes

Hi all,

I use TAdoTable/TAdoQuery and Oracle database,
some fields are declared like Number(12,3) for money.
DBEdit controls are used for these fields.
Through xxxxxxKeyPress(...), I can control letters inputed.
But you can still only input "-" or "+" as field value
and then move focus to another DBEdit or something else.
I implement BeforePost() event too, but still cannot catch DatabaseError
Exception.
Exception pops up :
"-" is not a valid floating point value for fiedl "xxxxxx".
please help me catch this exception.

Regard.
Wu JianHua.

Technical Details

Message-ID: <3e967ac0@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!small1.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,27df5231496d38a6,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-04-11 01:28:01 PST
From: "Wu JianHua" <wujianhua2000@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: DatabaseError Exception and BeforePost event
Date: Fri, 11 Apr 2003 16:18:57 +0800
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 61.163.228.70
Message-ID: <3e967ac0@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1050049216 61.163.228.70 (11 Apr 2003 01:20:16 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!small1.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail