invalid field size TADOQuery

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

Article #371

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

#371

From: siraj
Date: Thu, 21 Sep 2006 12:16

24 lines
1780 bytes

Hi,
I am using c++ builder and MS access 2000. I used the microsoft jet 4.0
oledb provider.
In one of the query,

sprintf(cmd,"SELECT
Avg(IIf(((Conc)*%lf)<((%lf)*%lf),(%lf)*%lf,((Conc)*%lf))) as AvgConc,Channel
FROM archives WHERE ((ts>= %lf AND ts<= %lf) AND Transit<>1 AND
DisplayFlag=true AND conc is NOT NULL ) GROUP BY
channe1",dMultiplicationFactor,dMinimumValue,dMultiplicationFactor,dMinimumV
alue,dMultiplicationFactor,dMultiplicationFactor,ss,ee);
    ReportConcADOQuery->Close();
   ReportConcADOQuery->SQL->Clear();
   ReportConcADOQuery->SQL->Add(cmd);
     ReportConcADOQuery->Open();

I am getting the error "EDatabaseError"  "Invalid field size".

Can any body help please.

I searched a lot but could not find a solution.

Regards,
Siraj

Technical Details

Message-ID: <4512829e$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,383859d72830abc4,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "siraj" <siraj.sm@omnisens.ch>
From: "siraj" <siraj.sm@omnisens.ch>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: invalid field size TADOQuery
Date: Thu, 21 Sep 2006 14:16:30 +0200
Lines: 27
Organization: omnisens
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
X-Antivirus: avast! (VPS 0638-0, 19/09/2006), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 212.109.69.36
Message-ID: <4512829e$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1158840990 212.109.69.36 (21 Sep 2006 05:16:30 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail