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.
