and
not the ODBC connection.
Buddy
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Paul C. Buckley
Sent: Thursday, August 3, 2017 2:13 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Problem with a Select Distinct Statement
Buddy,
Bill’s
PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Problem with a Select Distinct Statement
You can alias the table when you sattach especially if you’re not updating the
table. When updating or adding records I had to have the ‘dbo’ so all I did was
put IDQUOTES around the table name
, August 3, 2017 11:59 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Problem with a Select Distinct Statement
Is the "dbo" required? I'm starting a project connecting to SQL Server, and
we're not doing that
Karen
-Original Message-
From: Paul C.
gt;
To: rbase-l <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> >
Sent: Thu, Aug 3, 2017 10:55 am
Subject: RE: [RBASE-L] - Problem with a Select Distinct Statement
Buddy,
That didn’t work either, I still get the “Database dbo not connected” error.
Paul
From: rb
; Paul
>
> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
> [mailto:rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>] On Behalf
> Of Buddy Walker
> Sent: August 03, 2017 11:05 AM
> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.co
groups.com
Subject: RE: [RBASE-L] - Problem with a Select Distinct Statement
Paul
Since there is a dot in the column name try using the IDQUOTES around the
column name
Buddy
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Paul C. Buckley
Sent: Thursday, A
Buddy,
That didn’t work either, I still get the “Database dbo not connected” error.
Paul
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Buddy Walker
Sent: August 03, 2017 11:05 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Problem
Paul
Since there is a dot in the column name try using the IDQUOTES around the
column name
Buddy
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Paul C. Buckley
Sent: Thursday, August 3, 2017 10:41 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] -
8 matches
Mail list logo