<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><DIV><FONT color=#0000ff>Hi All,</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><FONT color=#0000ff>Please let me know if any one has knowledge of how to go about this in powerhouse 8.13.D version i.e I want to know the syntax.</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><FONT color=#0000ff>1) Create a dynamic query based upon the input text entered at the screen</FONT></DIV>
<DIV><FONT color=#0000ff>Execute it and display on the screen using .qks file</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><FONT color=#0000ff>or</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><FONT color=#0000ff>2) I have created a pl/sql procedure in the database which will create a dynamic query string .</FONT></DIV>
<DIV><FONT color=#0000ff>I need to know how to call this procedure in .qks file and execute the query and display the records on the screen.</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><FONT color=#0000ff>Any help on one of the two topics will be helpful.</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><FONT color=#0000ff>Thanks In Advance.</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><FONT color=#0000ff>Abhinetri.</FONT></DIV>
<DIV> </DIV></td></tr></table><br>
<!--1--><hr size=1></hr>
The INTERNET now has a personality. YOURS! <a href="http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/" target="_blank">See your Yahoo! Homepage</a>.