When I changed desktops, I didn't reinstall Oterro on this machine. I have
all the old 3.5 beta install files, but knowing that LAUNCH is just a
wrapper for ShellExecute, I am pretty sure you aren't going to get a return
value from LAUNCH.
----- Original Message -----
From: "Emmitt Dove" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, March 19, 2010 5:06 PM
Subject: [RBASE-L] - Re: Oterro Launching cmd.com
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
