Adding new fields

[Ruslan Zasukhin]

On 11/16/04 1:34 AM, "End If Software - Ralf Sander" <ralf at end-if.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 ]
-------------------------------------------------------------
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
-------------------------------------------------------------