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. > >
