I’m working with several different Freehand Data Providers. I’m having problems
using aggregate functions with when combining objects for net results from the different data providers. Can anyone give some advice on this matter?
Thanks for the help!
Hub Galbraith
Vanguard Cellular Systems, Inc.
Business Objects Support
Hubbard@vela.com
Listserv Archives (BOB member since 2002-06-25)
Think of Free-Hand SQL as the equivalent of SQL*Plus for Oracle – you are sending SQL directly to the database. The only functions that work from Free-Hand SQL are @variable and @script. The others are dependent on the existence of a universe in order to be translated to SQL which the database can understand. Therefore, these other @ functions, including @AggregateAware are incompatible with Free-Hand SQL, since Free-Hand SQL is used to bypass universes.
I’m working with several different Freehand Data Providers. I’m having problems
using aggregate functions with when combining objects for net results from the different data providers. Can anyone give some advice on this matter?
Listserv Archives (BOB member since 2002-06-25)
In a message dated 98-07-13 10:59:20 EDT, you write:
I’m working with several different Freehand Data Providers. I’m having
problems
using aggregate functions with when combining objects for net results from the different data providers. Can anyone give some advice on this matter?
Thanks for the help!
Hub Galbraith
Hub:
Your question is not totally clear. I am assuming that you are a) creating a document with multiple data providers (Free Hand SQL) and b) are attempted to do aggregate (sum, etc.) calculations between the data provided by the different data providers. I can’t think of why this would be a problem.
If you can provide a specific example then perhaps someone on the list can help!
Regards,
Dave Rathbun
Integra Solutions
www.islink.com See you in Orlando in '98!
Listserv Archives (BOB member since 2002-06-25)