Path: csiph.com!weretis.net!feeder8.news.weretis.net!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: Anton Shepelev <anton.txt@g{oogle}mail.com>
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: Creating a table in spite of browse mode
Date: Wed, 19 Oct 2022 17:52:14 +0300
Organization: A noiseless patient Spider
Lines: 23
Message-ID: <20221019175214.31c258599cdef0751e765686@g{oogle}mail.com>
References: <20221018150920.2c192912e8cb7da6002b965f@g{oogle}mail.com> <XnsAF34D5961846BYazorman@127.0.0.1>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: reader01.eternal-september.org; posting-host="c1cb9b86e90ea2b49b0ca6ad113795fe"; logging-data="76484"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX18Hj+Hspv2nvtntamNbU4g9lzsphVxhBzY="
Cancel-Lock: sha1:YvjEJUPmj9W5rUwS8z8AolAgFrY=
X-Newsreader: Sylpheed 3.5.0 (GTK+ 2.24.23; i686-pc-mingw32)
Xref: csiph.com comp.databases.ms-sqlserver:2163

Erland Sommarskog to Anton Shepelev:

> > SQL: CREATE TABLE #TEST(a INT)
> > ERR: CREATE TABLE is unsupported
>
> Is that the exact error message?

Yes.

> > SQL: BEGIN CREATE TABLE #TEST(a INT) END
> > RES: No error, but no table is created.
> >
> > SQL: SELECT 1 a INTO #TEST
> > ERR: Browse mode cannot be used with INSERT,
> >      SELECT INTO, or UPDATE statements.
>
> So what old and ugly client API is this?

Innovating and leading ERP software SAP Business One :-)

-- 
()  ascii ribbon campaign - against html e-mail 
/\  www.asciiribbon.org   - against proprietary attachments