Need "execute command" feature

[HayoOellrich]

I'm working with SF 6.0.0.4.

I have an install, where I want to write protocol entries into an Oracle database, when the user installs or uninstalls an application.

Fur this purpose, I have to call an SQL loader, which is in fact an exe-file somewhere on the network (lets say "sqlldr.exe").

I have to execute a command like
"sqlldr parfile=filename" (filename is some dynamic parameter).

Why isn't it possible to execute such a command directly from SF ? I have to create a bat-file instead containing this command, and then use the command "Execute (%AppDir%\callloader". In my case, this is very uncomfortable, because I install this file when installing, and I delete it, when the install finishes (the user shall not see it).

As a consequence, I have trouble when uninstalling, because I need it again.

Is there some workaround ?

Hayo

[Lorne]

Re: Need "execute command" feature

Um...why do you need to use a batch file?

Why not just use the Execute Program action with the "parfile=filename" part in the Command line arguments field?

Tip: set the Working directory field to the path where sqlldr.exe is, i.e. %AppDir%.

[HayoOellrich]

Re: Need "execute command" feature

Hi Lorne !

I am looking for some "Execute program" command, but did not find it. There is only an "Execute file", where I have to specify a complete path to the executable file.

Thats what I want to avoid ! The executable (.exe) resides on some network share, which is in the path. But the name and location of the share may vary for diff. OS and machines. So I do not want to search for the file first, because this may take time.

If I am able to simply submit a command, it would use the path to locate the executable.

Addendum:
Lorne, I tested "Execute file" by specifying "sqlldr" without any path, and it works ! Maybe you add this as an hint, because on your "execute file" screen, it says "path and filename" ?

Hayo

[This message has been edited by HayoOellrich (edited 04-12-2002).]

[Lorne]

Re: Need "execute command" feature

I'm glad you got it working.

BTW, yes I meant Execute File, not Execute Program...there is no Execute Program action (I was thinking of Execute File). Sorry about that.

Did you have to enter a path in the Working directory field to get it working, Hayo? Or did it work fine with that field empty?

[HayoOellrich]

Re: Need "execute command" feature

Hi Lorne,

yes, it's even working fine, if I leave the working directory field empty !

Thanks
Hayo

[Lorne]

Re: Need "execute command" feature

Cool. That's good information, thanks.