The Oterro instance is NOT in the Rbase Instance. That's why there is no GUI. If you remember, Oterro was created as an Extract from RBase as everything RBase except the GUI part. If there is going to be a mechanism in Oterro to be able to host an extraneous program allowing visual displays, it would have to be added to Oterro. Not to say that it won't be done or isn't being done, but the version you have is not going to work for you.
The best you can do is create something that polls for the marker file at whatever period of time works for you and if the marker file is present, display it then. The following is just my .02, which may be discarded or pondered.. I'm not going to belabor the issue of keeping current with the software, but it always amazes me that there isn't a second thought about getting the latest and greatest OS on a computer. I know there are holdouts that are still running XP, heck I have XP on the box I work on, the only holdback for me is the mountain of software installed on it takes me a day to install when I change the OS. But having said that, ALL the software I depend upon for my business IS up to date, including Visual Studio 12 and Delphi XE. I am pretty sure if you were up to date, we wouldn't be having this exchange of ideas for a kludge to make your program work the way you want. That's about all I can figure for you at this time. MIke ----- Original Message ----- From: <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, June 12, 2013 8:57 AM Subject: [RBASE-L] - RE: Oterro / Stored Procedure question Thanks for the further explanation. It does not appear it will be an option. In this system, I have no code that inserts the record or after. When World Ship processes a shipment record, there is an option to export that record to an ODBC. (In this case Oterro) So the insert is instigated by World Ship, not my code. Therefore I have no ability to insert code before or after the insert function. I thought I might be missing something on the Launch syntax as the Oterro help files state that Launch is supported and in stored procedures. Since everything worked like I needed when a record was inserted from an Rbase session, I was hoping that Oterro might need a little different syntax. Is it possible that Oterro is doing the launch, but somehow is prohibiting the screen display.? I.E. the launch runs, but started from a session that has no display console, it cannot display the pdf screen. I thought Launch ran an external command completely separate from the Rbase / Oterro thread, but I could very well be misunderstanding the function. I do know this. The trigger/sp launches the pdf file for viewing if a record is inserted from a Rbase session. If a record is inserted from an Oterro connection, either the Launch does not execute or the screen display is being suppressed. (All other code in the sp executes) I am not sure how to verify if the launch executes and the display is suppressed or if the launch command does not execute. I guess I can launch a batch file that writes a small text file. I can then check for the text file existence to see if Launch executed. While this may let me know what is happening, it will not solve my issue. (Can one TRACE a stored procedure processed by Oterro? I did not think so because there is no display console) In either case, I need to find some type of an option that allows me to display a message from within a stored procedure when triggered from Oterro. Thanks again everyone for the input. I am still looking for a solution. -Bob ----- Original Message ----- From: Mike Byerley <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, 12 Jun 2013 11:34:56 -0000 (UTC) Subject: [RBASE-L] - RE: Oterro / Stored Procedure question 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" To: "RBASE-L Mailing List" 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" 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 '' > write ' 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">' > > Write > .vSomeVarWithYourDataCompleteWithReturnsJustTheWayYouWantToDisplayIt > > write '' > > 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> > 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" > To: "RBASE-L Mailing List" > 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. > >
