Home » Developer & Programmer » Reports & Discoverer » How to run sql query
How to run sql query [message #617950] Sat, 05 July 2014 01:35 Go to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
hello.
a report contain of More than one sql query:
how to run this sql Queries?Parallel?
or Burst? (on what basis?)
Re: How to run sql query [message #617957 is a reply to message #617950] Sat, 05 July 2014 08:04 Go to previous messageGo to next message
Littlefoot
Messages: 21510
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Reports does it itself. I don't think that you, as a developer, have any influence on that.
Re: How to run sql query [message #617975 is a reply to message #617957] Sat, 05 July 2014 23:02 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
Yes, I know that Report Builder uses to manage its own
But I wanted her to know in what order to execute queries
Re: How to run sql query [message #617992 is a reply to message #617975] Sun, 06 July 2014 09:41 Go to previous messageGo to next message
Littlefoot
Messages: 21510
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm afraid I don't understand the question.
Re: How to run sql query [message #618055 is a reply to message #617992] Mon, 07 July 2014 06:23 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
for example:query1(q1),query2(q2)in a report.
Methods of Implementation q1,q2:
1.first q1 and then q2
2.first q2 and then q1
3.q1,q2 Together and parallel
Which of the above?
Re: How to run sql query [message #618065 is a reply to message #618055] Mon, 07 July 2014 07:56 Go to previous messageGo to next message
Littlefoot
Messages: 21510
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Your question still doesn't make sense to me. Implementation just depends on various parameters. For example, if it is a master-detail report, you'll first create a master query and then its detail. Obviously, you won't create them vice versa.
Re: How to run sql query [message #618238 is a reply to message #618065] Wed, 09 July 2014 13:56 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3149
Registered: May 2013
Location: World Wide on the Web
Senior Member
Sorry I don't use reports, however this seems to be something related to scheduling of SQL queries to execute one after another. Is it so?
Re: How to run sql query [message #618248 is a reply to message #618238] Thu, 10 July 2014 00:36 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
yes,I mean how could be executed.
Re: How to run sql query [message #618254 is a reply to message #618248] Thu, 10 July 2014 02:17 Go to previous message
Lalit Kumar B
Messages: 3149
Registered: May 2013
Location: World Wide on the Web
Senior Member
hahaie wrote on Thu, 10 July 2014 11:06
yes,I mean how could be executed.


Littlefoot wrote on Sat, 05 July 2014 18:34
Reports does it itself. I don't think that you, as a developer, have any influence on that.

Previous Topic: how to use param's in reports
Next Topic: how to implement in the oracle reports just create Data Model
Goto Forum:
  


Current Time: Mon Nov 18 16:30:09 CST 2019