Re: ESQL/C -- sqlturbo and sqldetach()

In <FORNEY.93Jan19085549@vega.bsdsun> forney@vega.bsdsun (Elizabeth Forney -- NEC America Network Management Group) writes: >I need the capability to access two databases at once from a single >application. With Version 5.00 of ESQL/C I noticed that there is a >sqldetach function now available. The manual is not quite clear, and I >am wondering if sqldetach allows me to process requests from two databases >at once, without closing one database before accessing the other? The >manual did not contain a code example. Could anyone on the net clarify the >use of sqldetach -- possibly with a code snippet illustrating its use? I get the impression you're barking up the wrong tree here. As I understand it sqldetach() allows a child process to detach from it's parent's sqlturbo. I don't understand why your requirement is not handled by code such as: DATABASE db1; INSERT INTO db2:tab2 SELECT * FROM tab1 WHERE ... since you imply you are using OnLine 5.0 (as SE can't do it) and I would call this one app accessing two databases??? graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. -------------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk -------------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it. -- graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc.