Article View: borland.public.cppbuilder.database.ado
Article #1551Re: Use of SQL MAX for MS ACCESS file
From: Viatcheslav V. Vassiliev
Date: Thu, 13 May 2004 19:27
Date: Thu, 13 May 2004 19:27
34 lines
2011 bytes
2011 bytes
ADO as any COM object throws EOleException. TDataSet could throw EDatabaseError. //------------------------------------------ Regards, Vassiliev V. V. http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + ADO.Net http://www.oledbdirect.com - The fastest way to access MS SQL Server, MS Jet (Access) and Interbase (through OLEDB) "Martin Moeller" <martin.moeller@moema.it> �������/�������� � �������� ���������: news:40a3c2f5$1@newsgroups.borland.com... > > "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote: > > > > > Your query may not work because there is no space between lines, finally > it > > looks as: > > > > SELECT * FROM ConfigHistoryWHERE Active=(SELECT MAX(Active) FROM > > ConfigHistory); > > > > Yes, just found it (proudly myself) a couple of minutes ago. > > What is the correct catch for ADO related exceptions? > > Tks, Martin > >
Technical Details
Message-ID:
<40a3cc34@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!controlnews3.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!newsfeed.gamma.ru!Gamma.RU!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<40a3b5c2$1@newsgroups.borland.com> <40a3be67$1@newsgroups.borland.com> <40a3bf2c$2@newsgroups.borland.com> <40a3c2f5$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,4ddc4486a34d3345 X-Google-Attributes: gid10698b,public From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com> Newsgroups: borland.public.cppbuilder.database.ado References: <40a3b5c2$1@newsgroups.borland.com> <40a3be67$1@newsgroups.borland.com> <40a3bf2c$2@newsgroups.borland.com> <40a3c2f5$1@newsgroups.borland.com> Subject: Re: Use of SQL MAX for MS ACCESS file Date: Thu, 13 May 2004 23:27:50 +0400 Lines: 36 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: 213.234.218.42 Message-ID: <40a3cc34@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1084476468 213.234.218.42 (13 May 2004 12:27:48 -0700) Path: arc1-ca.pugleaf.net!controlnews3.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!newsfeed.gamma.ru!Gamma.RU!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail