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

[Buddy Walker]

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: 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 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: rbase-l@googlegroups.com   
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: August 03, 2017 1:50 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.

 

Buddy

 

 

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Thursday, 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. Buckley  >
To: rbase-l  >
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-  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 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, August 3, 2017 10:41 AM
To:   rbase-l@googlegroups.com
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   
rbase-l+unsubscr...@googlegroups.com.
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   
rbase-l+unsubscr...@googlegroups.com.
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   
rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com 

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

[Paul C. Buckley]

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: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Buddy Walker
Sent: August 03, 2017 1:50 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.

 

Buddy

 

 

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Thursday, 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. Buckley  >
To: rbase-l  >
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-  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 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, August 3, 2017 10:41 AM
To:   rbase-l@googlegroups.com
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   
rbase-l+unsubscr...@googlegroups.com.
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   
rbase-l+unsubscr...@googlegroups.com.
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   
rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com 
 .
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 rbase-l+unsubscr...@googlegroups.com 
 .
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[Buddy Walker]

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:rbase-l@googlegroups.com] 
Sent: Thursday, 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. Buckley  >
To: rbase-l  >
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-  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 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, August 3, 2017 10:41 AM
To:   rbase-l@googlegroups.com
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   
rbase-l+unsubscr...@googlegroups.com.
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   
rbase-l+unsubscr...@googlegroups.com.
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   
rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com 
 .
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - My sincere thanks

[Paul C. Buckley]

Razzak,

I agree with Albert & Claudine. I contribute so much less than what I get out 
of R:BASE. I only wish more software companies were as responsive to their 
users as you are.

My sincere thanks to you and the Dream Team,
Paul

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: August 03, 2017 9:05 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - My sincere thanks

To R:BASE Community:

I would like to extend my sincere thanks to all the R:BASE users and developers 
listed below who have been instrumental in testing the official release of 
R:BASE X and R:BASE X Enterprise, Update 2, Build: 10.0.2.20731.

. Dan Angcao
. Marcos Antonio
. Albert Berry
. Paul Buckley
. Silvio J. Castaldi Jr.
. Silvio Castaldi Sr.
. Dan Goldberg
. Philippe Gosselin
. Richard Hopkins
. Adrian Hüssy
. Tony IJntema
. Fritz Lüttgens
. Gerusa Machini
. Stephen Markson
. Rob McDivitt
. Antonio Nicolini
. Mike Ramsour
. Claudine Robbins
. Peter Ryan
. Mohammed Sattar
. Ajay Sanghvi
. Ken Shapiro
. Rogério Yukio Shioya
. Richard Siegler
. Howard Simon
. Frank Taylor
. Armin Thoma
. Steve Vellella

R:BASE Technologies is fortunate to have such loyal and caring customers who 
are part of our success. Thanks for believing in our vision and helping us to 
provide you with the best of R:BASE.

We will continue to do our best and live up to your highest expectations. We 
will care for those who care about us. We will support those who believe in us 
and have much invested in R:BASE and R:BASE Technologies, Inc.

Thank you again for all your hard work and dedication.

Very Best R:egards,

Razzak.

www.rbase.com
www.facebook.com/rbase
--
34 years of continuous innovation!
19 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--

--
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 rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[Paul C. Buckley]

Karen,

 

The select * from dbo.sales_rep won’t work without the dbo. But I can’t get it 
working for the columns with or without it.

 

Thanks,

Paul

 

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: August 03, 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. Buckley  >
To: rbase-l  >
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-  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 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, August 3, 2017 10:41 AM
To:   rbase-l@googlegroups.com
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   
rbase-l+unsubscr...@googlegroups.com.
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   
rbase-l+unsubscr...@googlegroups.com.
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   
rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com 
 .
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - My sincere thanks

[Albert Berry]

Razzak - my thanks go to you. The only reason my name is here for helping you 
is for my own selfish reasons: getting your product to be better than anything 
else out there so I can impress my clients. 

Albert

> On Aug 3, 2017,
> at 7:05 AM, A. Razzak Memon  wrote:
> 
> To R:BASE Community:
> 
> I would like to extend my sincere thanks to all the R:BASE users and 
> developers listed below who have been instrumental in testing the official 
> release of R:BASE X and R:BASE X Enterprise, Update 2, Build: 10.0.2.20731.
> 
> . Dan Angcao
> . Marcos Antonio
> . Albert Berry
> . Paul Buckley
> . Silvio J. Castaldi Jr.
> . Silvio Castaldi Sr.
> . Dan Goldberg
> . Philippe Gosselin
> . Richard Hopkins
> . Adrian Hüssy
> . Tony IJntema
> . Fritz Lüttgens
> . Gerusa Machini
> . Stephen Markson
> . Rob McDivitt
> . Antonio Nicolini
> . Mike Ramsour
> . Claudine Robbins
> . Peter Ryan
> . Mohammed Sattar
> . Ajay Sanghvi
> . Ken Shapiro
> . Rogério Yukio Shioya
> . Richard Siegler
> . Howard Simon
> . Frank Taylor
> . Armin Thoma
> . Steve Vellella
> 
> R:BASE Technologies is fortunate to have such loyal and caring customers who 
> are part of our success. Thanks for believing in our vision and helping us to 
> provide you with the best of R:BASE.
> 
> We will continue to do our best and live up to your highest expectations. We 
> will care for those who care about us. We will support those who believe in 
> us and have much invested in R:BASE and R:BASE Technologies, Inc.
> 
> Thank you again for all your hard work and dedication.
> 
> Very Best R:egards,
> 
> Razzak.
> 
> www.rbase.com
> www.facebook.com/rbase
> -- 
> 34 years of continuous innovation!
> 19 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
> --
> 
> -- 
> 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 rbase-l+unsubscr...@googlegroups.com.
> 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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[Albert Berry]

Can you alias the SQL database to eliminate the ‘.’ from the name, perhaps?
Albert 
> On Aug 3, 2017, at 9:55 AM, Paul C. Buckley  wrote:
> 
> 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 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, August 3, 2017 10:41 AM
> To: rbase-l@googlegroups.com 
> 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 rbase-l+unsubscr...@googlegroups.com 
> .
> 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 rbase-l+unsubscr...@googlegroups.com 
> .
> 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 rbase-l+unsubscr...@googlegroups.com 
> .
> 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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[karentellef via RBASE-L]

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 
To: rbase-l 
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-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 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, August 3, 2017 10:41 AM
To: rbase-l@googlegroups.com
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 rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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 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, August 3, 2017 10:41 AM
To: rbase-l@googlegroups.com  
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 rbase-l+unsubscr...@googlegroups.com 
 .
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 rbase-l+unsubscr...@googlegroups.com 
 .
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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] - 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 rbase-l+unsubscr...@googlegroups.com 
 .
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[Paul C. Buckley]

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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - My sincere thanks

[A. Razzak Memon]

To R:BASE Community:

I would like to extend my sincere thanks to all 
the R:BASE users and developers listed below who 
have been instrumental in testing the official 
release of R:BASE X and R:BASE X Enterprise, Update 2, Build: 10.0.2.20731.


. Dan Angcao
. Marcos Antonio
. Albert Berry
. Paul Buckley
. Silvio J. Castaldi Jr.
. Silvio Castaldi Sr.
. Dan Goldberg
. Philippe Gosselin
. Richard Hopkins
. Adrian Hüssy
. Tony IJntema
. Fritz Lüttgens
. Gerusa Machini
. Stephen Markson
. Rob McDivitt
. Antonio Nicolini
. Mike Ramsour
. Claudine Robbins
. Peter Ryan
. Mohammed Sattar
. Ajay Sanghvi
. Ken Shapiro
. Rogério Yukio Shioya
. Richard Siegler
. Howard Simon
. Frank Taylor
. Armin Thoma
. Steve Vellella

R:BASE Technologies is fortunate to have such 
loyal and caring customers who are part of our 
success. Thanks for believing in our vision and 
helping us to provide you with the best of R:BASE.


We will continue to do our best and live up to 
your highest expectations. We will care for those 
who care about us. We will support those who 
believe in us and have much invested in R:BASE and R:BASE Technologies, Inc.


Thank you again for all your hard work and dedication.

Very Best R:egards,

Razzak.

www.rbase.com
www.facebook.com/rbase
--
34 years of continuous innovation!
19 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--

--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - Latest Updates of R:BASE X and R:BASE X Enterprise (Version 10)

[A. Razzak Memon]

Thanks, Claudine!

We appreciate the support of those who have always been loyal to R:BASE.

Very Best R:egards,

Razzak


At 04:26 PM 8/2/2017, Claudine Robbins wrote:

I spent thirty minutes yesterday reviewing the 
what's new pdf file for both enhancements and 
bug fixes.  It's amazing how much new stuff you guys come up with.


I guess that since you've always followed the 
same business model, we've become a bit blasé with your stellar development.


Apologies and thanks,

Claudine

-Original Message-
From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon

Sent: Wednesday, August 02, 2017 8:32 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Latest Updates of R:BASE X 
and R:BASE X Enterprise (Version 10)


To R:BASE Community:

I hope that all users with active R:BASE Software Assurance Plans
(R:SAP) had the opportunity to apply the latest 
updates of R:BASE X and R:BASE X Enterprise 
(Version 10), (Update 2, Build: 10.0.2.20731).


Reviewing the WhatsNewInRBASE_X_Update02.pdf 
document included with the update can be quite 
overwhelming since it includes all details about 
98 enhancements and 188 bug fixes.


The majority of the enhancements are the result 
of us working closely with our government and 
corporate customers, who are taking their 
complex and mission critical R:BASE XE 
applications to a whole new level, including 
full compatibility with MS SQL Server, deploying 
applications on the cloud, and designing and 
deploying complex web-portal applications using 
Java (using Oterro XE Version 10).


The latest updates of R:BASE X and R:BASE X 
Enterprise (Version 10), Update 2, Build: 
10.0.2.20731, also include smooth upgrade and 
transition tools when converting/upgrading from 
R:BASE for DOS to R:BASE X Enterprise.


We hope you all enjoy the hard work of the entire R:Dream Team!

The best is yet to come.

Very Best R:egards,

Razzak.

www.rbase.com
www.facebook.com/rbase
--
34 years of continuous innovation!
19 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--


--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Tip of the Day: Personalized Data Browser Location and Window Size

[A. Razzak Memon]

Thursday, August 3, 2017

Tip of the Day: Personalized Data Browser Location and Window Size
Product...: R:BASE X and R:BASE X Enterprise (Version 10)
Build.: 10.0.2.20731 or higher
Section...: Commands, Data Browser
Keywords..: EDIT, BROWSE, TOP, LEFT, WIDTH, HEIGHT

Did you know that the Data Browser window can be launched with a 
personalized and

pre-defined screen location and size?

The BROWSE and EDIT commands, to launch the Data Browser, have been enhanced to
include TOP and LEFT parameters to specify a different screen 
location for the grid
window. And, the WIDTH and HEIGHT parameters are also added to set 
the window size.


-- Example
   CONNECT RRBYW19
   CLS
   BROWSE ALL FROM Customer +
   OPTION CAPTION 'Customer Data' +
   |WINDOW_STATE NORMAL +
   |ROW_NUMBERS ON +
   |TOP 100 +
   |LEFT 100 +
   |WIDTH 1200 +
   |HEIGHT 700
   RETURN

One of the most important aspects in business growth is your company 
data, and no
one else has more invested in your success than R:BASE Technologies. 
Invest forward

with R:BASE!

Very Best R:egards,

Razzak.

www.rbase.com
www.facebook.com/rbase
--
34 years of continuous innovation!
19 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--

--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.