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]
