Calling MSaccess from OpenRoad Ingres

> I want to call msaccess from Openroad.  Openroad's call system
> does not work because msaccess cannot be run from a batch file
> within windows. Any ideas? Sendkeys or DDE ? I'm not sure?
>
> grassom@dpi.qld.gov.au

CALL SYSTEM 'msaccess';

should do the work for you !
(if access.exe is in the path, otherwise include the full path specification)
Why do you think, that only batch files can be called with CALL SYSTEM ?

If you don't like the behaviour of CALL SYSTEM, that it does't return
control to the OpenROAD program until the called executable has exited,
you can use the 3GL procedure WinExec, which is one of the Windows-API
functions.
Declare it as 3GL procedure (Language: PASCAL) in your component catalog
and call it by:

callproc WinExec('msaccess', int2(1));

1st param is the Windows program, 2nd is the show mode
(see Windows-SDK Ref.)
You have to set II_LIBU3GL in your CONFIG.ING before starting OpenROAD:
II_LIBU3GL=C:\WINDOWS\SYSTEM\KRNL386.EXE

/*----------------------*/
Bodo Bergmann
Client/Server- Consulting & Training
Frankfurt, Germany
bodob@ibm.net
Ingres Q & A
To William's Home Page

© William Yuan 2000

Email William