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