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/
