Re: Passing Information from 4ge's?
Posted in 1995
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
> Is there a way to pass information from one standalone 4ge running > another 4ge, back to the calling 4ge. > Here is the situtation. We have two standalone 4ge's. > The first 4ge (prog01) RUNS the second 4ge (prog02) passing it command > line agruments indicating which row prog01 had last queried. > If prog02 performs a query; how can I pass the new row information > back to prog01? The way I do this is to output the results to a file and then suck that file into a temp table... so you pass to prog02 an argument which is a file to store the output into... this file could be a BLOB file name we have a function which grabs a file one line at a time and puts it into a temp table... this is really pretty easy but if you want the source I will ask my mgr if I can send it to you. This works reliably and if you use BLOBs and temp tables then you don't have to worry about cleaning things up since this is done for you by 4GL. ============================================================================== | Brian Colfer -- colfer@informix.com | USA WC `94 A great cup! | Informix, Inc. Menlo Park, CA 94025 USA | ----- Sweden #3 ------ | work: 415-926-6352, home fax: 415-681-1378 | Arsenal, red and white forever! ==============================================================================