hello

[Ruslan Zasukhin]

On 5/23/06 8:39 AM, "dave" <dcaruso3 at verizon.net> wrote:

Hi Dave,

> just a question, simple i hope.
> 
> i have a database used as a playlist, i basicly just keep adding a new record
> for each song played, and delete each one as they are played, FIFO.

> what i would like to do is to add a record to the beginning of the list, like
> a priority play. 
> 
> now i did try to set the cursor with the FirstRecord command and added a
> record but it ended up at the end.

> what do i need to do to get this to work?

You cannot control the PHYSICAL ORDER of records in any way.
You can control only LOGICAL order.

To setup LOGICAL ORDER you can add on more column
And here assign order position for a record.
And you will use ORDER BY in your SELECT to get records sorted by order

> the only thing i can think of would be to read out all records,
> clear the database, then write them all back in in the order that i want.

This will not work for big dbs

> i cant just like reverse the order of play either because the other songs need
> to remain in the order that they were inserted. is there like some way to
> ripple the records down while forcing one in at the top?
> 
> once again
> thanks for you help
> 
> dave.

-- 
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]