var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Specify criteria for Connect By query
I have a simple query as follows:
start with id = 'bu0002'
connect by prior id = parent_id
This query does exactly what I want in that it returns all the business units below 'bu0002'.
I have a web based application that uses Crystal Reports 8. I want the user to be able to specify the Start With value at runtime.
Is this possible, and if so how might it be done?
You will probably have to use dynamic SQL to accomplish this ... Look at passing the PL/SQL your value and replacing the variable ... then use
It's the same as having a user pass a variable for a regular select. I don't know crystal reports, but your query would be something like "start with id = :bu".