🚀 go-pugleaf

If I copy the SQL statement outside of the property editor and execute it
interactively against the SQL Server, the query works fine.  Can someone else
try a SELECT DISTINCT query and tell me it works fine for them?

Arnie Mauer wrote:

> Hardee,
>
> Don't really know what your problem is, but it's not ADO.  It's up
> to SQL Server to process the request.
>
> - Arnie
>
> "Hardee Mahoney" <mahoney@nerdvana.fu.com> wrote in message
> news:3BA89961.92374FCA@nerdvana.fu.com...
> > Hello,
> >
> > BCB5 SP1 on NT
> >
> > I have an ADOConnection to a SQL Server 6.5 database using a Data Link
> > File.  I have an ADOQuery associated with that connection with the
> > following SQL:
> >
> > SELECT DISTINCT simple_plantype
> > FROM medigap_plantype_xwalk
> > ORDER BY simple_plantype
> >
> > I have a DataSource object and a DBGrid.
> >
> > The SQL statement returns all rows in the table, completely disregarding
> > the DISTINCT keyword.  Has anyone seen this?  Is there anything to fix
> > it short of reading all the rows and deduping them in code?
> >
> > Thanks in advance
> >
> > Hardee Mahoney
> > Washington, DC
> >
> >