🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #10220

Re: ��sybase system 11����ζ�̬�����?��������

#10220
From: Waiting
Date: Thu, 26 Mar 1998 00:00
18 lines
1406 bytes
> ==> Journey_Yu(�߳�����)                     ˵��: 
> ��sqlca.autocommit = true  
> it will go OK ! 
> cause create table ��������commit  
�����������������ð�?
˳�����:(�����������ڵĵ���λ��,���ǿ�Ц)
����һ��store procedure��,������select * into #temp from tablex
�����,����仰֮ǰ��������sql���,֮��Ҳ��,���ұ������Ķ���ȷ
֮�����commit,�Ҹ���ô��?
���sp��sybase��isql��ִ�еĺúõ�,return code=0,���Ҳ��Ԥ��,��
����pb��declare procedure��ִ�оͱ�"select into command not allowed 
with multi_statement transaction"�Ĵ�.������ִ�и����ʱ,ҲҪcreate
table #temp.
 

--
�� ��Դ: �й�ƴ�BBSվ [bbs.ustc.edu.cn]
Technical Details
Message-ID: <980326.yIAr1$PBBS@bbs.ustc.edu.cn>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB
X-Google-Thread: 101948,b0693f25ae18ab1e
X-Google-Attributes: gid101948,public
From: Zh_Hangjin@bbs.ustc.edu.cn (Waiting)
Subject: Re: ��sybase system 11����ζ�̬�����?��������
Date: 1998/03/26
Message-ID: <980326.yIAr1$PBBS@bbs.ustc.edu.cn>
X-Deja-AN: 337983546
Organization: �й�ƴ�BBSվ
Newsgroups: cn.bbs.comp.database