Myron, Temp tables are way cool because they do not grow the database and are truly multi-user. Each user only sees their instance of the table. And they are much faster than real tables so they are great for preprocessing data before dumping the result into permanent tables.
Alastair, It is my understanding that TEMP tables are not considered a structure change. You can do temp tables with STATICDB ON which does not allow structure changes. -- Dennis McGrath mailto:dennismcgrath@;sbcglobal.net -- Full time consultant with SQL Resources mailto:dmcgrath@;sqlresources.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]On Behalf Of Myron Finegold Sent: Saturday, October 19, 2002 7:10 AM To: [EMAIL PROTECTED] Subject: RE: Create Temp Table in EEP Alastair, Why not create a permanent table (BogusTbl), that remains empty until you need it, load it with data - do your thing and empty it. Below is a section of the eep I use. --USED FOR DETERMINING WHICH CLIENT TO BILL --START OF PROCESS LABEL TRYAGAIN SET VAR vDATE1 DATE, vDATE2 DATE DIALOG 'Enter the Invoice Date' vDATE1 = 8 vkey 1 at 15,4 DIALOG 'Enter the Period Ending Date' vDATE2 = 8 vkey 1 at 15,4 LABEL redoinpt --THIS SECTION GETS THE ACTIVE CLIENTS FROM CLIENT AND INSERTS IT INSERT INTO bogustbl (job#, job#suff, vpo_dt, thr_date, thr_inv#,+ thr_invm, partpay) SELECT job#, job#suff, vpo_dt, thr_date, thr_inv#,+ thr_invm, partpay FROM po_1 WHERE vendor# = .vvendor# AND+ dt_paid = '09/09/99' and balrem >= .01 order by thr_date UPDATE bogustbl SET paidnow = 0.00, tagflag = 'N' EDIT USING PAYMENTS Other stuff happens - then I INSERT INTO checktbl (check#, vendor#, chckdate, chckamnt, job#note)+ VALUES (.vcheck#, .vvendor#, .#date, .vchckamt, .vnotes) DELETE ROWS FROM BOGUSTBL (empties the table) Myron Finegold -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com] On Behalf Of Alastair Burr Sent: Saturday, October 19, 2002 3:12 AM To: R:Base ListServer Subject: Create Temp Table in EEP Hi all, Just checking up in case I'm setting up something which will come back and bite me: I have an EEP which works perfectly that creates a temp table, loads it with data, runs a cursor through it to update it, creates the data I want and puts it into a variable before dropping the table and returning to the form with the data displayed. R:>Syntax says, however, that changing the schema is a no-no in an EEP. Can I assume that creating a temp table does count as a schema change? eg: . Change the structure of your database, such as the CREATE TABLE command. Thanks & regards, Alastair. ---------------------------------- A D B Burr, St. Albans, UK. ---------------------------------- [EMAIL PROTECTED] ---------------------------------- ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
