Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: savery
- Order by date
-
Choosing a column based on a prompt?
You could create an object, say 'selectable month' with sql similar to this... case @prompt('Select month','A',,,) when 'Jan' then column_jan when 'Feb' then column_feb when 'Mar' then column_mar ... else 0 -- bad selection end Of course a prompt of fixed list values would be better..- savery
- Post #2
- Forum: Business Objects solutions
-
BO 5.1.1 / Oracle 8.1.7 Stored Procs Modifying DB
In BO you can call a user defined function in the select part of the object. if the function is a column function and you pass it a table.column value. Here we have sys.dual in the universe and use it to ensure function is called once (only one row in dual) eg SELECT...- savery
- Post #12
- Forum: Business Objects solutions
-
BO 5.1.1 / Oracle 8.1.7 Stored Procs Modifying DB
Just reading through this forum and am very interested in Orodam's comments on running stored procedures from objects. How do you do this? I have tried adding the suggested code to an object SELECT statement in Designer, but my PROC_NAME is not recognised (Oracle 8i stored procedure). On Parsing...- savery
- Post #11
- Forum: Business Objects solutions
