RE: datatable.select("Distinct") or such to string?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You might be interested in the assembly I've been working on at
http://www.queryadataset.com. Besides DISTINCT, it lets you perform complex
SQL SELECT statements including UNION, JOINS, GROUP BY, HAVING, ORDER BY,
sub-queries, etc against the tables in a dataset.

The web-site allows you to upload your own XML data fragment, DataSet or
resultset and issue queries using the QueryADataSet assembly.

Adrian Moore
http://www.queryadataset.com

---
"DEWright_CA@xxxxxxxxxxxxx" wrote:

> I am hitting a bit of a wall - I am building a table -
>
> public DataTable theTownships = new DataTable("AdjacentTownships");
> public DataTable buildTownshipTable()
> {
> DataColumn tscolumn; //Townships-Range Field
> tscolumn = new DataColumn();
> tscolumn.DataType = System.Type.GetType("System.String");
> tscolumn.ColumnName = "TSR";
> tscolumn.ReadOnly = false;
> tscolumn.Unique = false;
> theTownships.Columns.Add(tscolumn);
>
> return theTownships;
> }
>
> This table is built from another query where each coloumn in that row is
> turned into a row here. So I can have between 1 and 0 rows, some can be
> duplicates.
>
> What I need to do is then select the distinct rows from this table and pass
> them to a for loop that I can then parse/process each of the distinct rows.
>
> Any and all suggestions would be greatly appreciated!!
> --
> D @ premierdata
.

Relevant Pages

  • RE: Combining Queries
    ... I tried using the UNION command but unfortunately this ... > For some reports I have various Queries setup to collect various data. ... > Queries for each original Query. ... Below is the SQL for those. ...
    (microsoft.public.access.queries)
  • RE: Query set-up with two tables
    ... Post back your SQL, sometimes copying and pasting post introduces errors. ... "AccessKay" wrote: ... create another query to add the two and then try the Union again. ... I built queries and reports based on this table. ...
    (microsoft.public.access.queries)
  • Re: trouble with union query
    ... UNION SELECT ... These queries work fine in MS Access, but when I try to pull these queries ... I am totally a novice at SQL -- the SQL for union queries is about all I ... Can any of you decipher this error message for me? ...
    (microsoft.public.access.queries)
  • No results returned with JDBC query using UNION and DUAL
    ... I am trying to run the following sql using ... unless I ignore the fact that resultset ... union select 'CREATE PROCEDURE' priv from dual ...
    (comp.lang.java.databases)
  • Re: Graphical Union-Query Builder?
    ... If you are limiting the input in each of the sub-queries in your Union ... Use the filtered queries as the input to your Union query: ... Most "functional IT users" will not know anything about SQL. ... I didn't know that fields of subsequent queries in a Union could have ...
    (microsoft.public.access.queries)