ADOQuery AV...

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

Article #3068

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

#3068

From: Robert A. Vasquez
Date: Fri, 10 Jan 2003 18:33

14 lines
1389 bytes

Why would this code cause an AV...?

ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("SELECT Max(DateField) AS MaxDateField");
ADOQuery1->SQL->Add("FROM MyTable");
ADOQuery1->Open();

The Access Violation occurs right at the first line where the 'Select'
Command is issued.  The code doesn't even get as far as trying to open the
query.  The query also gets it's data from an Access table.  Any help
appreciated.

Robert

Technical Details

Message-ID: <3e1f12ac$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!oleane.net!oleane!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,c5885cd7f551afc6,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-01-10 10:40:45 PST
From: "Robert A. Vasquez" <rvasquez2001@yahoo.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ADOQuery AV...
Date: Fri, 10 Jan 2003 10:33:11 -0800
Lines: 16
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: 63.194.7.130
Message-ID: <3e1f12ac$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1042223788 63.194.7.130 (10 Jan 2003 10:36:28 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!oleane.net!oleane!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail