RE: [RBASE-L] - Problem with a Select Distinct Statement

2017-08-03 Thread Buddy Walker
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

RE: [RBASE-L] - Problem with a Select Distinct Statement

2017-08-03 Thread Paul C. Buckley
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

RE: [RBASE-L] - Problem with a Select Distinct Statement

2017-08-03 Thread Buddy Walker
, 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.

RE: [RBASE-L] - Problem with a Select Distinct Statement

2017-08-03 Thread Paul C. Buckley
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

Re: [RBASE-L] - Problem with a Select Distinct Statement

2017-08-03 Thread Albert Berry
; 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

Re: [RBASE-L] - Problem with a Select Distinct Statement

2017-08-03 Thread karentellef via RBASE-L
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

RE: [RBASE-L] - Problem with a Select Distinct Statement

2017-08-03 Thread Paul C. Buckley
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

RE: [RBASE-L] - Problem with a Select Distinct Statement

2017-08-03 Thread Buddy Walker
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] -