Article View: borland.public.cppbuilder.database.ado
Article #1739Lookup Fields throw an Exception
From: Ross McLeod
Date: Thu, 12 Feb 2004 02:49
Date: Thu, 12 Feb 2004 02:49
14 lines
1690 bytes
1690 bytes
I am using TADOQuery or TADODataSet and TADOConnection (haven't tried with TADOTable) and Builder 5 Enterprise. Within the Query or DataSet at design time a persistent field of type Lookup has been added. When an insert is performed an EOleException is thrown (message says Unknown error, typical of ADO components). The throw occurs somewhere between the insert and the OnNewRecord event. If I remove the Lookup field it stops. At present I've implemented a stored procedure to do the job with a calculated field. But Obviously it would be easier if I could solve this. Has anybody experienced this? Do I have the wrong version of ADO components? Can't seem to find anything on the Borland site regarding this. Ross McLeod
Technical Details
Message-ID:
<402ae9a2$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!newsfeed.tpinternet.pl!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: 10698b,5736fe558f2cb918,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2004-02-11 19:10:01 PST From: "Ross McLeod" <pittnet@bigpond.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: Lookup Fields throw an Exception Date: Thu, 12 Feb 2004 13:49:26 +1100 Lines: 16 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 NNTP-Posting-Host: 138.217.68.237 Message-ID: <402ae9a2$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1076554146 138.217.68.237 (11 Feb 2004 18:49:06 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!newsfeed.tpinternet.pl!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail