Hi Paul,
I am working on a project in R:tango, and in that project I created a TAF
that would allow me to execute SQL Statement on the database through the
web.
upon reading your question, I tried the following
create temporary table testcust (custname text(20)) <- worked
insert into testcust (custname) select custname from customer <-worked
select * from testcust <-worked and saw the data returned
drop table testcust <-worked
As for demand I don't know
One thing though, you should create the table with a name unique to the
current user
through directDBMS action so that no other user steps on it. and use
directDBMS actions
to work with this table
Ben Johansen
----- Original Message -----
From: "pdbordine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 5:47 PM
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
>
>
