Re: HELP:Forms4.5 - host command goes to DOS - Is that Right

In <41u8h7$k67_at_ob1.uws.EDU.AU>, A.Robb@.uws.edu.au (Andrew Robb) writes:
>We are writing a small application which requires the execution of 'GRANT
> SELECT, UPDATE...etc on tablename to username' to be run from withing
>Forms 4.5. We were going to do this by passing the username from the block
>to a sql script file on the PC which would the run the grants.
>
>Why when we use the HOST built-in does it drop out to dos and show
>'This Program requires Microsoft Windows'. I would have thought that
>the HOST for CDE Tools would have been windows.
>
>We want to have the GRANTING of table Priviledges done without having
>hardcode in any table names or usernames. We've managed to program it
>so that no hardcoding is done but we can't get HOST to run the
>plus31.exe executable.
>
>Any suggestions would be greatly appreciated.
>
>Also is there an FAQ for Forms 4.5 anywhere.
>
>Thanks.

It should work. I am currently working on an application that makes host calls to both plus31.exe and sqlload.exe. Did you try to qualify plus31.exe with it's full path name (you don't have to unless your path in your autoexec.bat file is incorrect or incomplete). Here is an example call to sqlplus:

 /* run sqlplus and and execute a sql script */

 host ('d:\orawin\bin\plus31.exe user/pw _at_e:\apps\myfile.sql');

 /* just run sqlplus */

 host ('d:\orawin\bin\plus31.exe');

Hope this helps.

M.Landa Received on Wed Aug 30 1995 - 00:00:00 CEST