🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

��sybase system 11����ζ�̬�����?��������

#10216
From: һ����
Date: Thu, 26 Mar 1998 00:00
33 lines
1475 bytes
����һ��script��

string  ls_sql

ls_sql = "create table location " + &
                "(loc_code char(6), " + &
                "state char(2), " + &
                "city char(20), " + &
                "address char(30), " + &
                "zip_code char(5), " + &
                "phone char(10))"


execute immediate :ls_sql;

if sqlca.sqlcode < 0 then
                MessageBox ("DataBase Error ", sqlca.sqlerrtext, exclamation!)
END IF


������anywhere���ؿ�����ʱ���������ɴ����±?��ͬ�����script������
system 11ʱ��ȴ���������ʾ��



the "CREATE TABLE" command is not allowed within a
 multi-statement transaction in the 'xxx'database.

ʵ���ż�����sql����ָ�㡣dddd�����������Ҿ�ˡ�

--
�� ��Դ:���人���ƻƺ�վ s1000e.whnet.edu.cn��[FROM: 202.114.7.221]
Technical Details
Message-ID: <3Ne0Ak$XSz@bbs.whnet.edu.cn>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 101948,787621280bb0ede8,start
X-Google-Attributes: gid101948,public
From: dddd.bbs@bbs.whnet.edu.cn (һ����)
Subject: ��sybase system 11����ζ�̬�����?��������
Date: 1998/03/26
Message-ID: <3Ne0Ak$XSz@bbs.whnet.edu.cn>
X-Deja-AN: 337978993
X-Filename: Database/M.890929678.A
Organization: �人���ƻƺ�վ
Newsgroups: cn.bbs.comp.database