valentina for director question

[Ruslan Zasukhin]

On 6/9/07 8:14 AM, "DAVID CARUSO" <dcaruso3 at verizon.net> wrote:

Hi David,

> basically what I am trying to do is to make a list
> and display a "window" of that list.
> I take the song data and sort it by artist, then I want to
> scroll through this list displaying a set number at a time.
> 
> I literal terms if I had this list on paper and had another piece of paper
> that had a "window" cut in it that showed 9 lines of this list, and I want
> to
> slide this "window" up and down the list based on what artist I was
> looking for, centered on this artist, but showing some above and below
> this centered artist.
> 
> the catch being that some of the artist in this list could be "locked out"
> so the list still being linear, but with some records not being shown.
> 
> example:
> say I have artist 1,2,3,4,5,6 in a numeric linear list they would be
> 1,2,3,4,5,6.  but if I have artist 4 locked out, then the list becomes
> 1,2,3,5,6,7. so if I am using a "position" to keep track of where I am
> at in the artist list the fourth position is actually the fifth artist.  and
> the fourth artist that is locked out could be unlocked, so this
> would further screw with "position".
> 
> so the idea was to build the cursor without  the "locked out" artist
> and then find the record position of my "centered" artist, so as to
> then build my list of nine artist to display on the screen. 4 artist above
> the centered artist and 4 artist below.  and by adding to or subtracting
> from my "position" i would then scroll through this cursor.
> 
> what do i need to do to accomplish this?

1) in REALbasic I know developers use hidden column or item of popup menu to
keep the position of that item in cursor.

    I think you can do this in Director also. Yes?
    At least should work hidden column of list


2) complex logic of LOCKED items ... Well, this is not task of DB, agree?
    its your task, and your logic, so you need self invent way how to
resolve it. May be you need keep own list of positions, then mark them
somehow as locked, then do search inside of this list to find real position
in cursor...   UP TO YOU :-)

Or may be you can convert cursor into List ot Property List ?
Also remembering here RecID of record
        SELECT RecId, * FROM ...

And if you need later UPDATE record you can use

    UPDATE ... WHERE RecID = valueFromList


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]