RE: Running 4GL on table that changes a lot

Posted in 2005

Dirk Moolman — Wed, 12 Jan 2005 12:20:13 +0200 — source: Usenet: comp.databases.informix

-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of scottishpoet Sent: 11 January 2005 07:07 PM To: informix-list@iiug.org Subject: Re: Running 4GL on table that changes a lot > >How about : > >read from the existing table > >populate a tempoary table with the new data > >drop the old table and rename the temp table to the name of the old >table The thing is, a record gets inserted, then the table is read, then another records gets inserted, and the table gets read again - etc. The table can't be created first, because the whole process reads from the table while it is being created ... :-/ sending to informix-list