SELECT INTO not allowed within multiple-statemet transaction

Hello

    I am working with Sybase and I have a SP that work with temporary table
cerated by "select into". This SP runs ok from the SqlAdvantage and it runs
well from PB Database Administrator, but when i execute it in run time show
the message "SELECT INTO  not allowed within multiple-statemet transaction".

        Any body can help me with this problem, please ???


                        Peter




0
Pedro
1/30/2003 10:44:38 PM
sybase.powerbuilder.database 9855 articles. 2 followers. Follow

2 Replies
729 Views

Similar Articles

[PageSpeed] 40
Get it on Google Play
Get it on Apple App Store

set SQLCA.AutoCommit to TRUE before executing the SELECT statement.

On Thu, 30 Jan 2003 19:44:38 -0300, "Pedro Aguila"
<pedro.aguila@cl.fjord.com> wrote:

>Hello
>
>    I am working with Sybase and I have a SP that work with temporary table
>cerated by "select into". This SP runs ok from the SqlAdvantage and it runs
>well from PB Database Administrator, but when i execute it in run time show
>the message "SELECT INTO  not allowed within multiple-statemet transaction".
>
>        Any body can help me with this problem, please ???
>
>
>                        Peter
>
>
>
>

0
joneil
1/31/2003 1:06:45 AM
you can try changing the properties to Sybase,the property to change is ddl
in tran in your main Database and the master Database. that I work to myself


atte . Erik Chacon

"Pedro Aguila" <pedro.aguila@cl.fjord.com> escribi� en el mensaje
news:sY98kULyCHA.254@forums.sybase.com...
> Hello
>
>     I am working with Sybase and I have a SP that work with temporary
table
> cerated by "select into". This SP runs ok from the SqlAdvantage and it
runs
> well from PB Database Administrator, but when i execute it in run time
show
> the message "SELECT INTO  not allowed within multiple-statemet
transaction".
>
>         Any body can help me with this problem, please ???
>
>
>                         Peter
>
>
>
>


0
Erik
1/31/2003 8:36:34 PM
Reply:

Similar Artilces:

Multiple Selection Listbox Within asp.net 2.0 Wizard INSERT Selected Items INTO SQL Database Using Stored Procedure or XML
Hi, newbie here, I'm trying to learn how to INSERT into SQL database the selected items from 12 multiple selection listboxes contained within a wizard. I'm not sure if I should use the stored procedure method or the XML method and do not know where to put the loop within the wizard code. Does anyone know any good links? I knew this code would only insert the number of selected items, but wanted to test it along with everything else in my wizard, which is inserting everything else fine using the StoredProcedure2. I've abbreviated the code (so not to overdo this post) to incl...

select into command not allowed within multi-statement transaction
Hello! We have a stored procedure, called from PB. After the start, appearing an error msg on the screen: "select into command not allowed within multi-statement transaction" Why? How can we eliminate? PB script: ======== IF b_ok THEN string s_sql s_sql = 'EXEC esp_kintlev_partner' + " '" + p_ank + "', '" + p_partner + "'" b_autocommit = partner.autocommit partner.autocommit = TRUE EXECUTE IMMEDIATE :s_sql USING partner ; IF partner.SQLCode <> 0 THEN MessageBox...

How to handle database transaction within multiple web forms?
I have a asp.net 2.0 web application. In one of the modules I have following scenario. In the UI there are 3 pages to take the input from the user. On the 1st page, we are inserting data in the master table and with the same we are beginning new sql transaction with the isolation level READ UNCOMMITTED. so that uncommited master table data can be read.  Master table has also has 4 detail tables. Then the user is navigated to 2nd and then to 3rd page where the user can enter multiple records in the detail tables. And only after finishing on the 3rd page, the transaction is commited. I w...

SELECT INTO command not allowed within multi-statement transaction.
I get the following error when trying to use a HTML Web DW from powersite that uses a stored procedure : ERROR: Retrieve Failed = -1 ***** Select error: SQLSTATE = S1000 [INTERSOLV][ODBC SQL Server driver][SQL Server]SELECT INTO command not allowed within multi-statement transaction. ************************ Isn't it posible to use stored procedures in a Web Datawindow ? Or is there another problem I didn't think of ? I am desperate for a quick response, so please help me ! Thanks, Gorik Francois Belgium Set AUTOCOMMIT to true to allow the db server to ...

Allowing multiple apps but not multiple database signons
I'm looking for suggestions on how to implement the following: We don't allow multiple instances of our application to run unless the client has the option to connect to more than one database. We now want to take that one step further and not allow the multi-DB clients to connect to a database that they are already connected to in another instance of the same app. (I hope that is clear!) Suggestions are very welcome. Let me know if I should post this in the connectivity newsgroup as well. TIA Bud Assuming you are using the createmutex approach, just define a n...

Select in Powerbuilder Database painter WORKS but does NOT in Powerbuilder run mode.
I have enclosed the actual information from a debug run. Will apprecaite any hints. Thanks Jim jimo@jdssc.com in ls_mod_string DataWindow.Table.Select="SELECT DISTINCT ~"inv_dtl~".~"inv_id~", ~"inv_dtl~".~"orig_cost~", ~"inv_dtl~".~"last_cost~", ~"inv_dtl~".~"regular_cost~", ~"inv_dtl~".~"orig_price~", ~"inv_dtl~".~"current_price~", ~"inv_dtl~".~"sugg_price~", ~"inv~".~"vend_id~", ~"inv~".~"style~", ~...

Select in Powerbuilder Database painter WORKS but does NOT in Powerbuilder run mode.
I have enclosed the actual information for a debug run. Will apprecaite any hints. Thanks Jim jimo@jdssc.com in ls_mod_string DataWindow.Table.Select="SELECT DISTINCT ~"inv_dtl~".~"inv_id~", ~"inv_dtl~".~"orig_cost~", ~"inv_dtl~".~"last_cost~", ~"inv_dtl~".~"regular_cost~", ~"inv_dtl~".~"orig_price~", ~"inv_dtl~".~"current_price~", ~"inv_dtl~".~"sugg_price~", ~"inv~".~"vend_id~", ~"inv~".~"style~",...

Transaction with multiple databases
Hi folks, I need to interact with multiple databases using ADO.NET. I have to maintain transaction across multiple tables that reside in different databases. How can this be achieved? Urgent!!!Cheers!!!Nitin SqlTransaction class check out: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqltransactionclasstopic.asp SamSam CromerSenior .NET Developer...

SELECTing from multiple databases
Hi - I wonder if any can advise me on the following issue? I need to run two active databases (e.g. This1.db and This2.db) I want to do an SQL SELECT operation on (say) Table 1 in This1.db and on (say) Table 2 in This2.db). I want to produce a DW report with the data selected from both tables, arising from two seperate databases. Can this be done? It seems to be that this operation can only be done by: a) first get the relevant data from Table 1 - by accessing This1.db. Save this accessed data in a temporary file. b) SELECT from the temporary file and Table2 in This2.db. ...

Multiple Transactions to SAME Database
We have two applications; each of which creates two transaction objects that connect to the same database. The first one, SQLCA, is the default for all datawindows, embedded sql, etc. The second, which is just another global descendant of n_tr, is only used for processing certain function/procedure calls to the database. Personally, I don't really see the need for this. I would much rather clean up the extraneous global transaction object, and make everything use SQLCA. Does anybody see any issues with my proposal? Thanks, Calvin On 6/9/2010 8:51 PM, Calvin A. Alle...

Checkbox Trouble
I am attemping the following to no avail.I want a user to be able to select multiple clients from a datagrid for transfer via checkboxes.  This step will only mark the clients via a database flag to be tranfered during another step. Once the clients are selected, user will click the update button.  I want the program to loop through the records within the datagrid and update a table via stored proc one at a time.  I keep getting a cast error (highligted in red), also I am not sure I am even coding it correctly.  If anyone could provide exampl...

superreview requested: [Bug 300779] Support multiple selection for xul:tree : [Attachment 190030] Allow space to be used for inc search in single select
Aaron Leventhal <aaronleventhal@moonset.net> has asked neil@parkwaycc.co.uk <neil.parkwaycc.co.uk@myrealbox.com> for superreview: Bug 300779: Support multiple selection for xul:tree https://bugzilla.mozilla.org/show_bug.cgi?id=300779 Attachment 190030: Allow space to be used for inc search in single select https://bugzilla.mozilla.org/attachment.cgi?id=190030&action=edit ...

superreview granted: [Bug 300779] Support multiple selection for xul:tree : [Attachment 190030] Allow space to be used for inc search in single select
neil@parkwaycc.co.uk <neil.parkwaycc.co.uk@myrealbox.com> has granted Aaron Leventhal <aaronleventhal@moonset.net>'s request for superreview: Bug 300779: Support multiple selection for xul:tree https://bugzilla.mozilla.org/show_bug.cgi?id=300779 Attachment 190030: Allow space to be used for inc search in single select https://bugzilla.mozilla.org/attachment.cgi?id=190030&action=edit ------- Additional Comments from neil@parkwaycc.co.uk <neil.parkwaycc.co.uk@myrealbox.com> In the File Bookmark dialog typing "New " now prefers "New Folder&quo...

CheckboxList Multiple selection to database
I need the user to be able to select more that one checkbox in the checkxlist. Can I populate my database with the checkbox results as follows. Client Table ID    Client     Areacodes1     XYZ         BN, HT, GT2     ABC        NB, TH, TG etc If you're going to store multiple selections within one field of your table, then you'll have to do all of the work. You might consider having a seperate AreaCodes table. However, ...

Web resources about - SELECT INTO not allowed within multiple-statemet transaction - sybase.powerbuilder.database

Resources last updated: 12/6/2015 5:48:35 AM