Problem with expression in Select Statement.

Thread View: borland.public.interbase.sql

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Jignesh Doshi Tue, 26 Nov 2002 23:57

#11293

Author: Jignesh Doshi
Date: Tue, 26 Nov 2002 23:57

17 lines
1491 bytes

"Select (SUM(ARCKDT - ARDUED)/COUNT(*)) as AVGDAYSLOW from ARMAST"

ARCKDT & ARDUED are TDatefield.

I am using this SQL to calculate this number & query executes without any
error. Now I want to show this number on the screen. But when I try the
following statement I get this error : "Cannot acces field 'AVGDAYSLOW' as
type float".

lblavgdayslow.Caption :=
FloattoStrf(Qry_.FieldByName('AVGDAYSLOW').AsFloat,ffnumber,5,2);

Please anyone have any suggestions...

Thanks..

Jignesh

Re: Problem with expression in Select Statement.

#11317

Author: Craig Stuntz TeamB
Date: Wed, 27 Nov 2002 14:30

16 lines
1540 bytes

In article <3de40a49@newsgroups.borland.com>, jdoshi@reliablegroup.com 
says...
> "Select (SUM(ARCKDT - ARDUED)/COUNT(*)) as AVGDAYSLOW from ARMAST"
> 
	Multi-posted.  I replied to this question in 
borland.public.interbase.general.

	Please do not multi-post.

	-Craig

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Re: Problem with expression in Select Statement.

#11318

Author: Jignesh Doshi
Date: Wed, 27 Nov 2002 15:22

23 lines
1886 bytes

I apologize for that..

Thanks

"Craig Stuntz [TeamB]" <cstuntz@nospamplease.com (but use vertexsoftware to
email)> wrote in message
news:MPG.184ea12242e45e1b98a289@newsgroups.borland.com...
> In article <3de40a49@newsgroups.borland.com>, jdoshi@reliablegroup.com
> says...
> > "Select (SUM(ARCKDT - ARDUED)/COUNT(*)) as AVGDAYSLOW from ARMAST"
> >
> Multi-posted.  I replied to this question in
> borland.public.interbase.general.
>
> Please do not multi-post.
>
> -Craig
>
> --
> Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
> Delphi/InterBase Weblog : http://delphi.weblogs.com
> InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
> InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads