Paul
Here are the steps I used with R:Tango,Oterro and RBW 6.5 on building Temp
Tables.
This worked fine but I did not test it under any type of major load.
The 5th action is dropping the table when you as soon as your are finished
with it.
These were all done using Direct DBMS.
This assign creates a unique name for the table.
<@ASSIGN NAME=vTableName SCOPE=USER VALUE='<@VAR SCOPE=USER NAME=VTabPart1>
<@VAR SCOPE=USER NAME=VFPEReviewsID>'>
****** 1st Action:
CREATE TEMPORARY TABLE <@VAR vTableName> (FPEReviewID
INTEGER,PartDeptDetID INTEGER,FPERemarks NOTE,PartIDNo INTEGER,Description
TEXT (350),PartDescription TEXT (50),FrstSort INTEGER,SecSort
INTEGER,ChairRank TEXT (4),ChairRemarks NOTE)
******2nd Action:
INSERT INTO <@VAR VTableName>
(FPEReviewID,PartDeptDetID,FPERemarks,PartIDNo,Description,
PartDescription,FrstSort,SecSort) SELECT
FPEReviewID,PartDeptDetID,FPERemarks,PartIDNo,Description,
PartDescription,FrstSort,SecSort FROM FacCommView WHERE FPEReviewID = <@VAR
VFPEReviewsID>
*****3rd Action
SELECT * FROM <@VAR VTableName> ORDER BY FrstSort,SecSort
******4th Action
Display the results
******5th and Final Action
DROP TABLE <@VAR VTableName>
Buddy
-----Original Message-----
From: pdbordine [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 8:48 PM
To: [EMAIL PROTECTED]
Subject: Temporary Tables Using Oterro
Has anyone tried using temporary tables through Oterro? I know that the
command works. I am concerned about deploying into heavy usage without any
experience to prove stability. Usage of temporary tables from the R:Base
client has stabilized in the last versions, and I use them extensively.
This is the first time I have needed them from Tango.
Any experience or advice is welcome!
Thanks,
Paul
