^^README/DISCLAIMER

All data and information provided on this site is for informational purposes only. Michael T. Bee makes no representations as to accuracy, completeness, currentness, suitability, or validity of any information on this site and will not be liable for any errors, omissions, or delays in this information or any losses, injuries, or damages arising from its display or use. All information is provided on an as-is basis.

WebFocus - Checking a Stored Procedure

...it's not the things you know for sure that get you -- it's the things you know for sure that ain't so...

I'd been messing about in a report and couldn't understand why my report columns weren't appearing. I'd made changes to SP and hadn't correctly generated the WebFocus master.

So, here's how to check a stored procedure:

• In Web Console / METADATA - right-click the master & click 'Sample Data'
• Change 'OUTPUT' to 'ANSWERSET1' in the 'Select output segment' dropdown
• In the heading row under 'Select input fields' -check the topmost checkbox
• Fill in the required parameters
• Click 'Sample Data' button

My QuickLaunch

On restart they tend to get re-arranged --
so to reorder ~ position my quick launch items
I snapped picture & documented...

!lefty_mouse	!righty_mouse	Backup
DOS	temp	RunHighlighted
CopyPlayTTS…	MakeUncList	SaveAsText…
Compare Suite	IE Drop…	Google Chrome
IE	FireFox	Opera
Safari	SeaMonkey	MWSnap
ChromeStart.vbs	Outlook	EditPlus
%{Tab}	Upper	Lower
Paste	+^{Tab}	^{Tab}
CopyAll	Undent	Indent
Size_win	ExeDeskPrev	ExeDeskNext
MyShowDeskTop	myODBCAD32	[WinSQL]
WebFocus	CrystalReports	Run
KVM1 Stage…	…Prod	…Logoff

The '.au3' scripts are AutoIt scripts. If you do any Q/A, testing, or development - this is a tool well worth your time.