Re: HELP - ERROR -408 !!!!

xrizzi@arcride.edu.ar wrote: : I need help : In the sentence CLOSE DATABASE occurs the error -408 : Example: : DATABASE rizzi@central : CLOSE DATABASE : ^^^^^^^^^^^^^^ : DATABASE local : How can I close the remote database and opening the local database without error? : Daniel Cernotto A few versions of Informix-4GL close the (network) database connection when executing a "CLOSE DATABASE" statement. A simple work-around is to PREPARE and EXECUTE that statement: Replace: CLOSE DATABASE With: prepare s_db_close from "close database" execute s_db_close That should keep the engine alive. Catalin. P.S. You can also create a function to perform the prepare/execute and re-use it every time you need to close the current database. -- =========================================================================== Catalin Badea _/_/_/ _/_/_/ _/_/_/ _/_/_/ _/ _/ _/_/_/ _/ _/ _/ _/ _/_/ _/ Senior Technical Architect _/ _/_/ _/ _/_/_/ _/ _/_/_/ _/ _/ _/ _/ _/ _/ Tecsys Inc. _/ _/_/_/ _/_/_/ _/_/_/ _/ _/_/_/ ====== cat@tecsys.com =========== include system "disclaimer.4gh" ======