Eliciting wisdom of the greater and mightier (than me) programmers

From: Craig Orson Oakland (COO I) <dotacion.nospam_at_st-helena.zzn.com>
Date: Wed, 29 Mar 2000 15:48:16 -0800
Message-ID: <8bu4hj$akt@gap.cco.caltech.edu>

I created a report in Designer 2.5 that utilises a table for temporary storage (just for the life of the report) which was added to a schema will call CITSSS. And yes, a synonym was also created.

The Before Parm Form trigger runs a do_sql query that populates (inserts records into) the table, then the After Report Query truncates the table.

Some of the weaknesses that are obvious to me are things that can be noticed but will most likely only happen during testing- like inserting duplicate records into the temp table, if I should be in Toad simultaneously while the report is running. But while I don't think this would ever happen in practice, is this a high-wire act or acceptable?

We don't have any code review at the moment, can anyone point out a better or stronger way to practice, mucho apreciado, and your advice, comments and suggestions invited!

--
(:(-(=(Craig O. Oakland (COO I)=)-):)
...owns rides and maintains
1) IBM Intellistation M 2) Nexar workstation (Nexar, r.i.p.)

http://home.pacbell.net/oioioioi/ Received on Wed Mar 29 2000 - 17:48:16 CST