The display of visual content won't work within the trigger/SP using launch.
You just need a few lines of code after the line of code that does the INSERT that fires the trigger, unless you are saying that INSERT is done from a different trigger, but somewhere AFTER those events, code returns to the calling program and there you check for the marker file and If present, execute the LAUNCH command. FWIW, you could stick with your PDF at that point, but the HTA is a much lighter weight option and will display everything you want, including graphics. After all, it is HTML. You can even include JavaScript inside your HTA to do many other things. The MSHTA.exe is nothing a user has to maintain or download for the display. It is on every windows computer from 2000 up. ----- Original Message ----- From: "Bob Thompson" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, June 12, 2013 1:04 AM Subject: [RBASE-L] - RE: Oterro / Stored Procedure question Thanks Mike. To better understand your directions.... Your instructions say to check for the file instance and Launch immediately after insert. I have no code other than what is in the stored procedure. A shipment is entered into World Ship via the World Ship screen interface. When the UPS label is printed, World Ship exports the shipment data via an ODBC (Oterro) connection to the Rbase database. There is no code I can change before or after the insert. All my code/ processing is done by the stored procedure, triggered by the Oterro insert. This procedure updates several systems in real time and is somewhat complex. It checks several rules as well. If a rule is broken, I must inform the World Ship user immediately to void the shipment and reprocess. I can handle the message content OK, I just cannot get it to display. Much of this system has been in production forca long time. We have multiple World Ship stations and process hundreds of shipments per day. This new and immediate requirement necessitates me to give an immediate message to the World Ship user if certain conditions are found. I can do it all so far except actually display the message from "Oterro" so to say. Your instructions state to use the launch command, which seems to be my issue. Are you stating to: 1: Use the launch outside the sp? If so, I am unsure that is an option or at least I am not understanding correctly 2: Are you stating that the HTA will work in the Oterro fired trigger where a PDF or other launched file would not? I will certainly give the suggestion a try, but wanted to understand the process better so I would have a better chance of success Thank you for the resonse. They are all appreciated Bob Thompson LaPorte, IN 219-363-7441 Sent from my iPod On Jun 11, 2013, at 5:52 PM, "Mike Byerley" <[email protected]> wrote: > 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. > >
