Index of fields

[Ruslan Zasukhin]

On 12/18/04 3:28 AM, "Ralf Sander" <ralf at end-if.de> wrote:

Hi Ralf,

Wait a moment. My last advice was to use query with DISTINCT.

  curs = db.SqlSelect( "SELECT DISTINCT name from T" )

Now you get cursor with unique vales from field. Sorted btw.

So no need to loop 


> Hi Ruslan,
> 
> sometime  ago we talked about the index of fields and how to access.
> Your hint with the loop through the works, but is not really fast, if
> there are a lot of records. And the index is already there. Isn't there
> a way to get the content of the index directly? Woudn't this be a nice
> feature? It would be a great help to have realtime access to all values
> of a field.
> 
> Cheers,
> Ralf Sander
> 
> PS. May be you have overseen my mail depending the beta download
> because of a wrong date setting of my mac:
> 
>> V4RB 2 beta and Vserver 2 beta are available?
>> Where is the downlaod lin?
>> 
>> I have frequently checked :
>> http://www.paradigmasoft.com/files/v4rb_beta.html
>> but I have only found 2.0a65.
> 
> 
> 
> 
> 
> 
> 
> 
>> On 11/16/04 1:34 AM, "End If Software - Ralf Sander" <ralf at end-if
>> DO.T de> wrote:
>> 
>> Hi Ralf,
>> 
>>>>> How can I get the index (the index used for find and sort, not the
>> id)
>>>>> of a field or method as a string.
>>>>> Like "Show Index" in filemaker
>>>> I have not understand a question.
>>> 
>>> sorry, starting with the wrong subject makes confusion complete.
>>> 
>>> I'll try to explain better:
>>> 
>>> assume a field name with 3 records:+
>>> 1. Ralf
>>> 2. Ruslan
>>> 3. Someone else
>>> 
>>> 
>>> The index of the this field should contain
>>> "Ralf
>>> Ruslan
>>> Someone else"
>>> separated by returns
>>> That's how I know it from filemaker, and I thought, its the same in
>>> Valentina.
>> 
>> Hmm, I never have hear about such "feature" of FileMaker.
>> 
>> And I am sure this is NOT normal for most DBMS.
>> 
>>> Now i want to get this complete index as a string:
>>> "Ralf
>>> Ruslan
>>> Someone else"
>> 
>>> This would be much more easy (and faster) than getting all values,
>> and
>>> removing duplicates. Possible?
>> 
>>> By the way, there is a function in Filemaker to get all values of a
>> field in
>>> a cursor as a string :
>>> assume a field "name" with 5 records in a cursor:
>>> 
>>> 
>>> 1. Ralf
>>> 2. Ruslan
>>> 3. Someone else
>>> 4. Ruslan
>>> 5. Ruslan
>>> 
>>> 
>>> This function returns the result:
>>> "Ralf
>>> Ruslan
>>> Someone else
>>> Ruslan
>>> Ruslan"
>>> 
>>> Possible, too?
>> 
>> Ralf,
>> 
>> You work in REALbasic ?
>> 
>> You can and you should make this self in one small function which in
>> loop
>> iterate records and build string in ANY format you want.
>> 
>> Do not worry about speed. Valentina in any case will be MUCH faster of
>> FM.
>> 
>> About duplicates. You need do next:
>> 
>>  curs = db.SqlSelect( "SELECT DISTINCT name from T" )
>> 
>> Now you have cursor with list of names that do not have duplicates.
>> 
>> 
>> 
>> -- 
>> Best regards,
>> Ruslan Zasukhin [ I feel the need...the need for speed ]
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------