Home Scripts TopTools Misc Resume Tamil JobSearch
MyFontYourFont BqrMultiDb TpqcHtm1000 TpqcPhp1003 BrowserQueryRunner ClipRunRightClick RightClick FourKey MakeHtm	TpqcHtm1000 Just enter your connect string & source directory, Create a brand new htm script library!   TpqcHtm1000 is a realtime, point-and-click Oracle sqlplus script library generator. It accepts a connect string and a browsable source directory as inputs and produces a htm- formatted report library. All you need is an XP pc that can run sqlplus! Features:  -Creates a htm script library from any oracle script directory on your pc -Resizable frame borders -Original source directory is intact as TpqcHtm1000 uses a copy of the scripts -Formats even select statements into htm reports but accepts commonly used formatting commands -Spool filename commands need to be commented out -User inputs with & or &&, missing / or ; at the end of script may cause TpqcHtm1000 to freeze, always use task manager to keep a tab on and remove any frozen or long-running sqlplus.exe's. -Plsql will produce unformatted reports -TpqcHtm1000 is hta but can be renamed to html to be viewed by most browsers Requirements:  An XP Pc that can run sqlplus. Install Instructions:  1.Download TpqcHtm1000.zip and extract to a folder. 2.Run TpqcHtm1000.Install.bat. Run Instructions:  Double Click on TpqcHtm1000.exe, enter the connect string and either enter a source directory or select from the folder browser. Click Generate library now button and accept the safe login prompt. Click on script to view your script and scriptname-data to run it and view the output.   Check Script, Run & View Output SelectDir SafeLogin CheckScript CheckRunner Output!     Search And Run Web Query SelectBrowser SearchForQuery OpenPage RunShtmCrrc Output!         Uninstall Instructions:  -Run TpqcHtm1000.Uninstall.bat from where you unzipped the zip file. The uninstaller cannot delete the install directory if files are opened by browsers or hta windows or sqlplus. Debugging Tips:  -If you do not get an output, check the script source to make sure it does not have & for user input, has a / or ; to run the script. -Check the file used to store the connection string[C:\Sqlhtm\Tpqc\Htm\Tpcstr.txt] and the file used to store Source directory[C:\Sqlhtm\Tpqc\Htm\Tpsdir.txt] and make sure that there are no leading or trailing whitespaces. -connect string examples: 1. system/manager@xe  2. sys/change_on_install@xe as sysdba Safety:  Backup your source directory, enter correct connect string and always verify the connect string on the title bar before using TpqcHtm1000 to produce reports. Free Licence: TpqcHtm1000 is free for your personal/non-commercial use. You are welcome to make a donation if you find it useful. Thanks. Disclaimer: By using this tool you agree that backing up your source scripts, entering correct connect string and source directory during use of this tool are your responsibility and that Neutratek-sqlhtm.com is not responsible for any unwanted results arising from the use of this tool. Thanks: Apache ApacheFriends.org F2ko Filezilla Google GreenGeeks Hostmonster Html-form-guide Iview Internet.com Java2s.com Msdn Oracle Oracle-base Optimumx Php Pspad Sothink Sqldeveloper Stackoverflow Ssr Tektips Unixutils Yahoo visualbasicscript.com   Flash Banner
Home Scripts TopTools Misc Resume Tamil JobSearch
www.sqlhtm.com  Copyright. Jerome S. Christopher. 2010