No Subject

[Paul Hoyte <phoyte@SHARIDIONNE.COM>]

Hello Phillip:

The problem is with the sequencing of the statements.


BEGIN-SQL

 create global temporary table temp1
 on commit delete rows
 as select * from emp;  ---this line can be replaced with your actual column
definitions



END-SQL

Take a look at the attached sample program that I wrote.  It works just fine
without any problems.  Hope this helps.

Paul Hoyte
Sharidionne, Inc.
(248) 559-6868
www.sharidionne.com
phoyte@sharidionne.com

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Philippe Godin
Sent: Thursday, May 31, 2001 2:27 PM
To: SQR-USERS@list.iex.net
Subject:


We're using SQR Workbench compiler from Scribe but as an editor we're using
Ultra-Edit32 (which I don't think the problem can be related to...) The
version of SQR is 4.0.3 and yes your quite good in french!
Hope this helps

Philippe

-----Message d'origine-----
De : Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]De la part de Paul Hoyte
Envoyé : 31 mai, 2001 14:16
À : SQR-USERS@list.iex.net
Objet :


Hello Phillip:

If my French is still correct, it appears that you are having a page fault
occur.  Is this correct?  and if so, can you provide the configuration in
which you are executing your SQR programs? Thanks

Paul Hoyte
Sharidionne, Inc.
(248) 559-6868
www.sharidionne.com
phoyte@sharidionne.com

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Philippe Godin
Sent: Thursday, May 31, 2001 2:09 PM
To: SQR-USERS@list.iex.net
Subject:


Good day,

    This is my problem if anyone can help... I'm trying to create temp
tables in SQL Server and Oracle in order to make any further requests more
efficient. Those requests are quite complex and any select statement is not
enough for my needs. I've tried to use arrays but it makes the report a
whole lot longer to execute and processing more complicated. So this is it,
I've succeded with SQL Server 7.0 to acheive my goal by doing this:

Begin-Sql
Select whatever into #temptable from mytable where blablabla;
End-Sql

The problem is with Oracle (version 8.1.5 and up), since the supported
platforms have to be both SQL Server and Oracle.

I've did some research and the previous command wouldn't work. I found that
there is a way to create a temp table by doing this:

Create global temporary table mytable (
field1 varchar2(20) not null,
field2 number(2)
) on commit delete rows;

This statement works using SQL * PLUS but not from SQR by inserting the
command between Begin-Sql and End-Sql tags.

This is the result of executing this program:

SQRWT a causé une défaillance de page dans
 le module SQRWT.DLL à 0167:1003b9e0.
Registres :
EAX=00d4030c CS=0167 EIP=1003b9e0 EFLGS=00010206
EBX=00000000 SS=016f ESP=0070e468 EBP=00000000
ECX=00e91a60 DS=016f ESI=00e50530 FS=44f7
EDX=10070b8b ES=016f EDI=00000005 GS=0000
Octets à CS : EIP :
0f bf 01 c1 e0 05 8b 90 ec 1e 0b 10 85 d2 74 15
État de la pile :
0070fc04 00000000 00000000 00000054 00000001 40000000 656c6573 00007463
0054504c 00000004 00000000 00000080 00000186 000013e6 0147747f 0147747f

Anyone have any ideas or seen this before? Or is there any other way to
create a temp table in Oracle?

Thanks in advance
Philippe Godin

sample_sqr.sqr