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
