InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: InstantDB: Aggregate expression with math expressionproblem


Doug

Try AVG ((C1*C2)*C3).

Regards

Pete

----- Original Message -----
From: Doug Thistlethwaite <doug.t@deltanet.com>
Date: Monday, January 15, 2001 2:05 am
Subject: InstantDB: Aggregate expression with math expression problem

> I just downloaded instantDB last week and I am trying to get it 
> workingwith a project I am working on.  I have a table where I 
> have several
> values I want averages on.
> 
> Assume a table "T" with columns C1,C2,C3,C4 all long values
> 
> The following statements work:
> select avg(C1) from T
> select avg(C1*C2) from T
> select avg(C1*5) from T
> 
> This statement does not work:
> 
> select avg(C1*C2*C3) from T
> select avg(C1*C2*5) from T
> 
> For some reason, it there are three or more values in the mathmatical
> expression, instantDB returns a error that it found a * where it
> expected a ) symbol.  Does anybody have a workaround for this problem?
> 
> Thank you!
> 
> Doug Thistlethwaite
> 
> P.S: I saw some old messages on integrating JBuilder with 
> instantDB but
> no answers.  If anybody is still looking for this info, let me 
> know and
> I will post the solution that is working for me.
> 
> 
> -------------------------------------------------------------------
> ----------
> To unsubscribe from this mailing list, send email to 
> majordomo@enhydra.orgwith the text "unsubscribe instantdb" in the 
> body of the email.
> If you have other questions regarding this mailing list, send 
> email to
> the list admin at owner-instantdb@enhydra.org.
> 

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.