Create a marker file on disk. Make certain it has the file extension .HTA like: MyMarkerFile.HTA
If it has to be multiuser friendly, then map it to a folder in the users Application Data folder, where there are no Read/Write issues. Then: At the beginning of your SP, delete any previously created instances of the marker file.. Process your data and create whatever Textual output you wish to display in a variable of whatever datatype will contain everything, TEXT or NOTE. Then using the WRITE statement do this: Write '<HTML><HEAD><TITLE>RBase Html Report Viewer</TITLE>' write '<HTA:APPLICATION ID="oHTA" APPLICATIONNAME="RBase Html Report Viewer"' write 'BORDER="thick" BORDERSTYLE="complex" CAPTION="yes" CONTEXTMENU="yes" MAXIMIZEBUTTON="yes"' write 'MINIMIZEBUTTON="yes" SCROLL="yes" SHOWINTASKBAR="yes" SINGLEINSTANCE="yes" SYSMENU="yes"' write 'VERSION="1.0" WINDOWSTATE="NORMAL" ICON="RBase.ico"></HEAD><BODY><PRE>' Write .vSomeVarWithYourDataCompleteWithReturnsJustTheWayYouWantToDisplayIt write '</PRE></BODY></HTML>' Then check for the existence of the marker file immediately AFTER the insert is done in the next line of code and if the file is found, then Launch '"MyFullyQualifiedMarkerFileNameIncludingDoubleQuotesIfThereIsANY SPACES IN THE FILENAME"' I have tested this and it works just fine. You "might" have to do something with your AV to allow extension HTA to run. What is HTA? Microsoft Hypertext Application. It is Internet Explorer WITHOUT all the baggage and overhead of full blown IE. The file that will show up in task manager that is the host is MSHTA.exe. If you want to customize the display then you can remove the <PRE></PRE> tags, which just display text just as you write it inside the tags. You could insert your own tags for font, size, color, etc. ----- Original Message ----- From: "Javier Valencia" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, June 11, 2013 5:52 PM Subject: [RBASE-L] - RE: Oterro / Stored Procedure question Have you tried tracing the process to makes sure if the LAUNCH command itself is not executing or if it aborting before then? Have you tried turning messages and error messages on to see if you get nay warnings? Also, I have had luck in the past creating the command as variable and using it with the LAUNCH command: Instead of: Launch G:\RBTI\UPS\ErrorDoc.pdf Use: SET VAR vMyLaunch TEXT = ‘G:\RBTI\UPS\ErrorDoc.pdf’ LAUNCH &vMyLaunch Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, June 11, 2013 4:04 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Oterro / Stored Procedure question One of those days.. :( I have an urgent project with a very short time constraint and am not having much luck today. What's new in Oterro 8 lists : 1.2 R:BASE Turbo V-8 Fully compatible with R:BASE Turbo V-8 specific enhancements · New #NOW System Variable · Support for Stored Procedures and AFTER Triggers · Support for LAUNCH Command · Support for LAUNCH Command in Stored Procedure/Triggers However I cannot get LAUNCH to work in an insert trigger with Oterro. If I add a record to the triggered table from the R> with an insert command, the stored procedure runs and the LAUNCH command in the stored procedure works as expected. When Oterro adds a record to the same table, the store procedure does run, but the Launch command does not execute. My command is : Launch G:\RBTI\UPS\ErrorDoc.pdf Is my syntax correct? (the .pdf extension is correct as it works from the R> insert) I have also tried other document formats such as jpg etc. I have an absolute requirement to display a screen message if certain data requirements are not met with the Oterro foreign data insert. I can collect and test the data, in the stored procedure/trigger, but have not found a way to display the screen message. When Oterro inserts a record, data is checked and if not correct, the message must display real time on the monitor of the processing computer. Any other possible, reasonably quick solutions? I am hoping I am missing something with the above syntax with Oterro. The Launch command would be perfect if I can figure it out. Otherwise, I have found no other way to display this message. Thanks, it is much appreciated.
