Re: Problem with multiple databases in a single 4GL program

[some text deleted] > Specifically, we are trying to merge two databases which reside into two > different directories into a third database. We use statements > > DATABASE "dbname" > CLOSE DATABASE > > to open and close each database respectively. [some text deleted] > > Any help will be appreciated.... > > Iakovos Karakas Based on my own experience: In SE you can use temporary tables to transfer data between different databases; I've had no problem performing the next sequence of operations: - open source database - create temporary tables for the transfer - close source database - open destination database - populate tables In OnLine 5.0 although you can open only one database, you still can manipulate directly multiple databases in your sql statements (the requirement is that all databases have logging) -- Maximo Maldonado B. Information Services ITESM-Campus Monterrey Mexico mmaldona@mtecv2.mty.itesm.mx