Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Creating a table in spite of browse mode
4 views
Skip to first unread message
Anton Shepelev
Oct 18, 2022, 8:09:24 AM10/18/22
to
Hello, all
The application I am working with quietly imposes some
limitation on its connection to MSSQL that will not let me
create a temporary table. Below are some of my attempts with
the corresponding results:
SQL: CREATE TABLE #TEST(a INT)
ERR: CREATE TABLE is unsupported
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.
On the other hand, that same connection allows anything
within dynamic SQL, but of course it is executed in its own
context and has no effect on the parent context. What else
can I try to coax it into creating a table, or is there no
chance?
Yes, I know that it smells bad, but sometimes one has to
choose the lesser evil while in reverse-engineering and
fixing poorly maintained legacy software. Originally, it
used a separate connection to create a global temporary
table with a GUID for name, and to pass that name as a
parameter to many user-supplied stored procedures, which had
to be written in dynamic SQL...
--
() ascii ribbon campaign - against html e-mail
/\ www.asciiribbon.org - against proprietary attachments
The application I am working with quietly imposes some
limitation on its connection to MSSQL that will not let me
create a temporary table. Below are some of my attempts with
the corresponding results:
SQL: CREATE TABLE #TEST(a INT)
ERR: CREATE TABLE is unsupported
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.
On the other hand, that same connection allows anything
within dynamic SQL, but of course it is executed in its own
context and has no effect on the parent context. What else
can I try to coax it into creating a table, or is there no
chance?
Yes, I know that it smells bad, but sometimes one has to
choose the lesser evil while in reverse-engineering and
fixing poorly maintained legacy software. Originally, it
used a separate connection to create a global temporary
table with a GUID for name, and to pass that name as a
parameter to many user-supplied stored procedures, which had
to be written in dynamic SQL...
--
() ascii ribbon campaign - against html e-mail
/\ www.asciiribbon.org - against proprietary attachments
Erland Sommarskog
Oct 18, 2022, 2:59:52 PM10/18/22
to
Anton Shepelev (anton.txt@g{oogle}mail.com) writes:
> The application I am working with quietly imposes some
> limitation on its connection to MSSQL that will not let me
> create a temporary table. Below are some of my attempts with
> the corresponding results:
>
> SQL: CREATE TABLE #TEST(a INT)
> ERR: CREATE TABLE is unsupported
Is that the exact error message?
> The application I am working with quietly imposes some
> limitation on its connection to MSSQL that will not let me
> create a temporary table. Below are some of my attempts with
> the corresponding results:
>
> SQL: CREATE TABLE #TEST(a INT)
> ERR: CREATE TABLE is unsupported
> 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.
>
Anton Shepelev
Oct 19, 2022, 10:52:18 AM10/19/22
to
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 :-)
> > SQL: CREATE TABLE #TEST(a INT)
> > ERR: CREATE TABLE is unsupported
>
> Is that the exact error message?
> > 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?
Erland Sommarskog
Oct 19, 2022, 4:43:28 PM10/19/22
to
Anton Shepelev (anton.txt@g{oogle}mail.com) writes:
> Innovating and leading ERP software SAP Business One :-)
>
That may not be in scope for this newsgroup, I'm afraid. Better find a forum
>
for SAP.
Anton Shepelev
Oct 20, 2022, 5:05:51 AM10/20/22
to
Erland Sommarskog:
> That may not be in scope for this newsgroup, I'm afraid.
> Better find a forum for SAP.
Their support and forums are hopeless, especially with
regard to such questions. It took them two years to add the
mandatory Date: field to e-mails sent with their SMTP client
:-) I was asking here for some cunning, unusual, hackery,
and perverted ways to create tables in SQL, which I could
try to bypass the limitation in SAP software.
> That may not be in scope for this newsgroup, I'm afraid.
> Better find a forum for SAP.
regard to such questions. It took them two years to add the
mandatory Date: field to e-mails sent with their SMTP client
:-) I was asking here for some cunning, unusual, hackery,
and perverted ways to create tables in SQL, which I could
try to bypass the limitation in SAP software.
0 new messages