Focal Point
SQL passthru with Resource Layout Painter

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6151078331

June 30, 2005, 03:45 PM
gypsy
SQL passthru with Resource Layout Painter
Has anyone executed a report through RLP that uses SQL pass thru to Oracle db?

I have a report that runs well (using autoprompts with parameter defaults), until I try to "create hyperlink" with a multiselect listbox. I can't get the "MultiSelect" attribute set to "OR", it populates with "None" and it is grayed out so it can't be modified.

I've gotten multiselects to work with FOCUS queries, but now I have to run some queries using SQL passthru. RLP doesn't pick up the &MYMULTISELECT.(OR(1,2)). syntax when its embedded in the SQL passthru.
July 11, 2005, 09:16 PM
Kerry
Hi gypsy,
Has the issue regarding SQL passthru been resolved?
I ran a quick search of Focal Point posts and came across the following topics which may be of interest:
SQL passthru - easy example needed
https://forums.informationbuilders.com/eve/forums/a/...551008331#6551008331 SQL passthru problem with 525
https://forums.informationbuilders.com/eve/forums/a/...181078331#5181078331 Another suggestion would be to open a case with Information Builder's Technical Support Help Desk. Please either call Technical Support Help Desk at 1-800-736-6130, or access the online system InfoResponse at http://techsupport.informationbuilders.com <br /><br />Hope this helps.
Cheers,
Kerry

This message has been edited. Last edited by: <Mabel>,