SQLSelect Question

[Don Toro]

Yes. The cursor should contain records 1, 3, 4, 5 and 7.

Donard Toro
Information Manager/Computer Programmer
-------------------------------------------------------------------
Thinking Publications, a division of
McKinley Companies, Inc.
424 Galloway Street, Eau Claire, WI 54703
Phone: 1.800.225.4769 (US) & 1.715.832.2488
Fax: 1.800.828.8885 (US) & 1.715.832.9082
www.ThinkingPublications.com
-------------------------------------------------------------------
COMMUNICATION SOLUTIONS THAT CHANGE LIVES
Specializing in resources for individuals
with speaking, listening, reading, writing, and thinking skill deficits


-----Original Message-----
From: Chuck Pelto [mailto:cbpelto at pcisys.net]
Sent: Thursday, February 02, 2006 1:54 PM
To: Valentina Developers
Subject: Re: SQLSelect Question


Would this allow for records 3, 4 and 7 to be in the cursor?

Regards,

Chuck


On Feb 2, 2006, at 12:43 PM, Don Toro wrote:

> It looks like you want to remove any duplicate records from the  
> result. Try the following query.
>
> SELECT DISTINCT Field1, Field2 FROM Table
>
> Donard Toro
> Information Manager/Computer Programmer
> -------------------------------------------------------------------
> Thinking Publications, a division of
> McKinley Companies, Inc.
> 424 Galloway Street, Eau Claire, WI 54703
> Phone: 1.800.225.4769 (US) & 1.715.832.2488
> Fax: 1.800.828.8885 (US) & 1.715.832.9082
> www.ThinkingPublications.com
> -------------------------------------------------------------------
> COMMUNICATION SOLUTIONS THAT CHANGE LIVES
> Specializing in resources for individuals
> with speaking, listening, reading, writing, and thinking skill  
> deficits
>
>
> -----Original Message-----
> From: Chuck Pelto [mailto:cbpelto at pcisys.net]
> Sent: Thursday, February 02, 2006 1:39 PM
> To: Valentina Developers
> Subject: SQLSelect Question
>
>
> This is a rather generic question regarding an SQLSelect call. And I
> hope I do not offend anyone with the simplicity of it, as I do not
> know how to phrase the search in this situation.
>
> I've got a table with multiple fields in it. Heh...like that's
> anything new.
>
> I want to select data from two fields, as part of building this
> contextualmenu (CM) on the fly.
>
> I want the data to be selected to be any records where the
> information in the two fields is distinctly different from any other
> records in that table.
>
> For example...
>
> Field1		Field2		RecID
> A			B			1
> A			B			2
> A			C			3
> A			D			4
> B			B			5
> B			B			6
> B			A			7
>
> I would want to cursor to include records 1, 3, 4, 5 and 7. Omitting
> records 2 and 6, because it already has their combinations of data.
>
> How would I phrase the SQLSelect text?
>
> SELECT Field1, Field2 FROM theTable WHERE..........?
>
> Regards,
>
> Chuck
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina