Index of fields

[Ralf Sander]

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 ]