🚀 go-pugleaf

It is happening at the line where the query is opened.
ReportConcADOQuery->Open();

The "invalid field size" error  is occuring randomly on the same command.

Some times it does not give an error at all

The sql command is

SELECT
Avg(IIf(((Conc)*1.000000)<((0.020000)*1.000000),(0.020000)*1.000000,((Conc)*
1.000000))) as AvgConc,Channel FROM archives WHERE ((ts>= 38952.000000 AND
ts<= 38962.000000) AND Transit<>1 AND DisplayFlag=true AND conc is NOT NULL)
GROUP BY Channel;


Regards,
Siraj

"Bob Swart" <b.swart@chello.nl> a �crit dans le message de
news:45128B9C.6030609@chello.nl...
> Hi siraj,
>
> > 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);
>
> I guess it would help to show the result of this "cmd" after the sprintf
> command (I don't have the mental capacity right now to produce it in my
> head right now).
>
> >    ReportConcADOQuery->Close();
> >    ReportConcADOQuery->SQL->Clear();
> >    ReportConcADOQuery->SQL->Add(cmd);
> >    ReportConcADOQuery->Open();
> >
> > I am getting the error "EDatabaseError"  "Invalid field size".
>
> You could set breakpoints to find out there the error is happening. I
> have a feeling it's simple happening at the Open() command, because
> something is wrong inside the "cmd" itself...
>
> Please just post an example of the cmd you're using here. Perhaps one of
> the field values is empty (or NULL) in some cases?
>
> > Siraj
>
> Groetjes,
>            Bob Swart
>
> -- 
> Bob Swart Training & Consultancy (eBob42.com)  Forever Loyal to Delphi
> Blog: http://www.drbob42.com/blog - RSS: http://drbob42.com/weblog.xml
> New Delphi 2006 Courseware e-books at http://www.eBob42.com/courseware