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

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

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

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,

RE: [RBASE-L] - My sincere thanks

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

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

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:

Re: [RBASE-L] - My sincere thanks

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

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

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:

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

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

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] -

[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

[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 .

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

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

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

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