Paul,
I created my own SQL Server database, so none of the columns have “dbo” in
front of them
SQL Server Table Name - dbo.Tablename
I would sattach it as dbo.Tablename another sattach as alias dboTablename
When all I want to do is get a count or get a distinct column would do this
SELECT DISTINCT(columnName) FROM dboTablename
When doing an INSERT from R:Base to SQL Server Table I would
INSERT INTO `dbo.Tablename` (columnList) SELECT columnList FROM R:BaseTable
I’m also connecting to the SQL Server database using the DSNless string and
not the ODBC connection.
Buddy
From: [email protected] [mailto:[email protected]] On Behalf Of
Paul C. Buckley
Sent: Thursday, August 3, 2017 2:13 PM
To: [email protected]
Subject: RE: [RBASE-L] - Problem with a Select Distinct Statement
Buddy,
Bill’s suggestion of using the column number worked but if you could give me an
example of what you are using that works that would be great too.
Thanks,
Paul
From: [email protected] <mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Buddy Walker
Sent: August 03, 2017 1:50 PM
To: [email protected] <mailto:[email protected]>
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.
Buddy
From: karentellef via RBASE-L [mailto:[email protected]]
Sent: Thursday, August 3, 2017 11:59 AM
To: [email protected] <mailto:[email protected]>
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. Buckley <[email protected]
<mailto:[email protected]> >
To: rbase-l <[email protected] <mailto:[email protected]> >
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: rbase- <mailto:[email protected]> [email protected] [
<mailto:[email protected]?> mailto:[email protected]] On Behalf
Of Buddy Walker
Sent: August 03, 2017 11:05 AM
To: rbase- <mailto:[email protected]> [email protected]
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: <mailto:[email protected]> [email protected] [
<mailto:[email protected]> mailto:[email protected]] On Behalf Of
Paul C. Buckley
Sent: Thursday, August 3, 2017 10:41 AM
To: <mailto:[email protected]> [email protected]
Subject: [RBASE-L] - Problem with a Select Distinct Statement
Good morning,
I'm running the latest build of R:BASE X Enterprise. I have a connection to a
SQL database & about 6 or 8 SQL tables attached. I'm trying to create a SQL
Select Distinct statement and can't get the syntax correct. Here's what I've
tried:
SELECT DISTINCT dbo.sales_rep.id AS rep_id, sales_rep.NAME-ALIAS from
dbo.SALES_REP
Error is:
SELECT DISTINCT sales_rep.id AS rep_id from dbo.SALES_REP
Error is:
But this works without error: SELECT * from dbo.SALES_REP
Any blues clues?
Thanks,
Paul Buckley
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to <mailto:[email protected]>
[email protected].
For more options, visit <https://groups.google.com/d/optout>
https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to <mailto:[email protected]>
[email protected].
For more options, visit <https://groups.google.com/d/optout>
https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to <mailto:[email protected]>
[email protected].
For more options, visit <https://groups.google.com/d/optout>
https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected]
<mailto:[email protected]> .
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected]
<mailto:[email protected]> .
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected]
<mailto:[email protected]> .
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
