[comp.databases] Running external programs from within dBASE3+ application?

brand@janus.Berkeley.EDU (Graham Brand) (03/29/91)

Can someone tell me if it possible to run an external program from 
within a dbase3+ application and then use the results to update a
database. An example of this would be to call up an external 
database from within the application.

Cheers,
-Graham

mdb@abcom.ATT.COM (3030 ) (04/02/91)

From article <41489@ucbvax.BERKELEY.EDU>, by brand@janus.Berkeley.EDU (Graham Brand):
> Can someone tell me if it possible to run an external program from 
> within a dbase3+ application and then use the results to update a
> database. An example of this would be to call up an external 
> database from within the application.
> 
> Cheers,
> -Graham

To run an external program within Dbase III+ all you need to do is 
RUN <program>

	example:  RUN MYPROG

Note:  You will need to make sure that you have enough memory to do
	the RUN command.

Mike Barnes
(415) 224-3030

alan@ahmcs.uucp (Alan Mintz) (04/05/91)

In article <41489@ucbvax.BERKELEY.EDU>, brand@janus.Berkeley.EDU (Graham Brand) writes:
> Can someone tell me if it possible to run an external program from 
> within a dbase3+ application and then use the results to update a
> database. An example of this would be to call up an external 
> database from within the application.

While it is not particularly efficient (compared to dBase LOAD, etc), 
the RUN command will run any external program, script (or batch) file,
etc.

We use it to put a Foxbase+ user interface on a relatively complex
matrix calculator written in C. The matrix is exported to a .txt file, the
C program is run to massage the file, the results are written to 
a second file, then Foxbase+ is used to import the file back into a database.

...
USE input
COPY TO infile.txt TYPE SDF
RUN c_prog && Turns infile into outfile
USE output
APPEND FROM outfile.txt TYPE SDF
...

-- 
< Alan H. Mintz             | Voice +1 714 980 1034 >
< Micro-Quick Systems, Inc. | FAX   +1 714 944 3995 >
< 10384 Hillside Road       | ...!uunet!ahmcs!alan  >
< Alta Loma, CA  91701 USA  | alan@mq.com           >