SQLSelect Question

[Chuck Pelto]

Great!

Now if I can just figure out how to create and manipulate an  
ArraySet, I think I'll have this part of my learning curve in this  
activity whipped.

Thanks,

Chuck

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

> 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
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>