Home » Developer & Programmer » Reports & Discoverer » Changing SQL
Changing SQL [message #243877] Sun, 10 June 2007 14:05 Go to next message
spooja
Messages: 25
Registered: May 2007
Junior Member
Can Somebody tell me at the time of runtime can we change SQL in Reports?
Re: Changing SQL [message #243882 is a reply to message #243877] Sun, 10 June 2007 16:55 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you explain what you, exactly, want to do? If we know the problem, we might provide a better solution. I believe that simple YES or NO aren't the answers you need.
Re: Changing SQL [message #243891 is a reply to message #243877] Sun, 10 June 2007 18:37 Go to previous messageGo to next message
spooja
Messages: 25
Registered: May 2007
Junior Member
Somebody asked me this question in an interview whether you can change the SQL during runtime or not?
Re: Changing SQL [message #244417 is a reply to message #243891] Tue, 12 June 2007 13:20 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi,

Then I think you should first search it Why yes or No. Then better learn it for next interiew. Read about Dynamic sql also.

Ashu
Re: Changing SQL [message #244429 is a reply to message #243877] Tue, 12 June 2007 14:52 Go to previous messageGo to next message
spooja
Messages: 25
Registered: May 2007
Junior Member
Thats what I asked whether it is yes or no?
Re: Changing SQL [message #245702 is a reply to message #244429] Mon, 18 June 2007 10:14 Go to previous message
Madhu_bala
Messages: 16
Registered: January 2007
Location: Chennai, Now at Saudi Ara...
Junior Member

U can change the sql at run time using Dynamic SQL.
But it too have some limitations.
Previous Topic: How to disply Physical Page No. on all but last page
Next Topic: Problem in the format of output in Excel (merged)
Goto Forum:
  


Current Time: Tue Dec 03 04:47:32 CST 2024