Thanks Razzak, but I'm not sure it's going to be the help Thom is looking
for.
He has an EXE he wants to launch. That EXE is just a wrapper for the
XMLHTTP request object to a remote server running PHP.
The EXE is designed to collect a return value from the remote server and
beyond that I don't know how the EXE passes the return value back to the SP
he uses to call the EXE.
Since it worked in 7.6, but didn't work in the Oterro session, I thought he
had possibly AV or something on that machine that prevented the EXE from
running (like spawning a process from a virus).
----- Original Message -----
From: "A. Razzak Memon" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, March 19, 2010 5:17 PM
Subject: [RBASE-L] - Re: Oterro Launching cmd.com
Emmitt,
I will upload the requested document as soon as I reach the mainland.
My iPhone does not have R:Upload app <g>.
Very Best R:egards,
Razzak.
Sent from my iPhone
On Mar 19, 2010, at 5:06 PM, "Emmitt Dove" <[email protected]>
wrote:
I don't know that Razzak would have the 3.0 What's New online any more.
Emmitt Dove
Manager, Converting Applications Development
Evergreen Packaging, Inc.
[email protected]
(203) 214-5683 m
(203) 643-8022 o
(203) 643-8086 f
[email protected]
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of MikeB
Sent: Friday, March 19, 2010 17:01
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Oterro Launching cmd.com
I don't have Oterro installed. What's the link to the online?
----- Original Message -----
From: "Emmitt Dove" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, March 19, 2010 4:30 PM
Subject: [RBASE-L] - Re: Oterro Launching cmd.com
See WhatsNewInOterro30.pdf.
Emmitt Dove
Manager, Converting Applications Development
Evergreen Packaging, Inc.
[email protected]
(203) 214-5683 m
(203) 643-8022 o
(203) 643-8086 f
[email protected]
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of MikeB
Sent: Friday, March 19, 2010 16:13
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Oterro Launching cmd.com
OK. The normal thing to do would be to have the Scripting language do
the
request, depending on the result from the stored procedure. Not having
done
a LAUNCH from a SP, I will take it from Emmitt that it is permissible.
I take it the following is in the SP?
SET VAR vLaunch = 'LAUNCH request.cmd'
&vLaunch
If it is, I don't see how you get a value into vLaunch as LAUNCH
doesn't
have a mechanism to return a variable.
Is request.cmd a dos batch file or an RBase command file?
----- Original Message -----
From: "Thomas Cimicato" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, March 19, 2010 3:35 PM
Subject: [RBASE-L] - Re: Oterro Launching cmd.com
ok...well.....I built an IVR system that uses ODBC to connect to the
RBase
database using the Oterro 3.5 driver. The IVR works great reading and
writing to the Rbase database through Oterro ODBC driver and executes
the
stored procedure from a trigger just dandy. Its the stored procedure
executed by Oterro that needs to launch a DOS command file that runs
cURL.exe.
I don't know what language the IVR system was written in. My IVR
scripts
are called Callmaster Basic. Its an interpreted scripting language for
that IVR system (kinda like rbase command files are interpreted by
Rbase).
So its not compiled Oterro Dll's. We are using the Oterro ODBC driver
to
get to the database.
I have even tried to use the Rbase 7.6 ODBC driver for the IVR and
that
works fine too. Its the launch command in the stored procedure that
won't
run. Maybe its my syntax for the launch command in the stored
procedure.
SET VAR vLaunch = 'LAUNCH request.cmd'
&vLaunch
Thom
MikeB wrote:
Also Thom, you haven't said what programming language you are using
for
the front end to Oterro, or is the Oterro instance on the server
being
accessed by your RBase sessions on the Lan and the Wan?
----- Original Message ----- From: "Thomas Cimicato"
<[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, March 19, 2010 12:20 PM
Subject: [RBASE-L] - Oterro Launching cmd.com
Can Oterro 3.5 running a stored procedure "launch" a command line
process .bat or .cmd file? I can get it to work in my local RBase
7.6
environment but Oterro does not seem to execute the launch. Oterro
executes the stored procedure/trigger nicely it but it doesn't
execute
the "launch test.bat" DOS command file that I need the stored
procedure
to run.
Will Oterro execute a UDF if I convert the batch file to a UDF of
some
sort?
Any comments are welcome.
Thanx
Thom
