Index of fields

[Ralf Sander]

Hi Ruslan,
yes, but but nevertheless I have a lot of records to loop through.
What I have in mind:
I want to create a visual representation of record creation dates and 
times. This could be a lot of values and creating this chart could take 
some time. Accessing the values in the index would be much faster, I 
think.

The need for speed, you know ;-)

Cheers,
Ralf


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