Rajkumar and Rendy, the problem is not with the select permission. If you are
creating a temp table it must be done outside of a transaction. If you are letting
PB manage your transactions (Autocommit = FALSE) then a transaction is always open
and running. To use a temp table you must set autocommit to TRUE and manage the
transaction yourself:
1. set sqlca.autocommit = TRUE
2. create your temp table
3. create your transaction (if you are doing any updates)
4. set sqlca.autocommit = FALSE to restore your previous setting
Personally, I would advise managing the transactions yourself ALL the time, keeping
autocommit set to TRUE. Switching back and forth is inviting problems. Also, by
letting PB keep a transaction open all the time you can run into problems with the
transaction log on your DB server.
HTH
Rajkumar Chilamula wrote:
> check the select permission on table and as well as the columns in the table
> which you are selecting to create the temp table.
>
> Raj
>
> >From: Rendy Theixar <[EMAIL PROTECTED]>
> >To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
> >Subject: PFCSIG problem with Filter Service at dataobject datawindow
> >Date: Fri, 30 Jul 1999 15:47:02 +0700
> >MIME-Version: 1.0
> >From [EMAIL PROTECTED] Fri Jul 30 04:07:02 1999
> >Received: from [198.3.220.11] by hotmail.com (2.1) with ESMTP id
> >MHotMailB96AD2500128D8219796C603DC0BF5990; Fri Jul 30 04:07:02 1999
> >Received: (from majordom@localhost) by mango.rssi.com (8.8.4/8.8.2) id
> >FAA03207 for pfcsig-outgoing; Fri, 30 Jul 1999 05:10:01 -0400 (EDT)
> >X-Authentication-Warning: mango.rssi.com: majordom set sender to
> >[EMAIL PROTECTED] using -f
> >Received: from out5.ibm.net (out5.ibm.net [165.87.194.243]) by
> >mango.rssi.com (8.8.4/8.8.2) with ESMTP id FAA03203 for <[EMAIL PROTECTED]>;
> >Fri, 30 Jul 1999 05:09:54 -0400 (EDT)
> >Received: from suryakertas.com (slip202-135-135-117.sb.id.ibm.net
> >[202.135.135.117]) by out5.ibm.net (8.8.5/8.6.9) with SMTP id IAA72692 for
> ><[EMAIL PROTECTED]>; Fri, 30 Jul 1999 08:52:51 GMT
> >Received: from BSD_RENDY [127.0.0.1] by kedungdoro.suryakertas.com
> >[192.168.1.36] with SMTP (MDaemon.v2.7.SP3.R) for <[EMAIL PROTECTED]>; Fri,
> >30 Jul 1999 15:47:01 +0700
> >Received: by BSD_RENDY with Microsoft Mailid <01BEDAA2.C7080020@BSD_RENDY>;
> >Fri, 30 Jul 1999 15:47:07 +0700
> >Message-ID: <01BEDAA2.C7080020@BSD_RENDY>
> >X-MDaemon-Deliver-To: [EMAIL PROTECTED]
> >Sender: [EMAIL PROTECTED]
> >Precedence: bulk
> >
> >ASAP
> >
> >I've got problem using PFC. I've tell you from the start. I use PB 6.5 for
> >front end and Sybase Adaptive Server v11.9.2 for the back end.
> >I use dataobject u_dw and I've activate the filter service for that
> >datawindow.
> >And I ran the program, the program ran succesfully, but if I click the
> >'Value' Tabpage at Build filter with, an error was occur.
> >That error was :
> >The database error has occured
> >Select error: The 'CREATE TABLE' is not allowed within a multi-statement
> >transaction in the 'tempdb' database
> >How can I solve this problem ?
> >
> >--------------------- "The greatest good we can do for others is not to
> >share our riches but to reveal theirs" ---------------------
> >Rendy Theixar
> >PT. Surabaya Agung Industri Pulp & Paper Tbk
> >Email : [EMAIL PROTECTED]
> >URL : http://www.suryakertas.com
> >
> >
> > > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
> >ADDRESS
> > > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
> >pfcsig
> > > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
>
> _______________________________________________________________
> Get Free Email and Do More On The Web. Visit http://www.msn.com
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
