valentina for director question

[Ruslan Zasukhin]

On 5/9/07 10:43 PM, "dave" <dcaruso3 at verizon.net> wrote:

Hi Dave,

> i have a database of song titles with fields for album artist and title

> i build a cursor like so
> select * from songs where lockout = 0

> i need to find the record number of the cursor based
> on then artist field

> so how would i get the record number of the cursor for artist field = "rush"

Why you need this?
Only by some linear search...


Actually this is not normal practice.
Any DBMS do not allow you do SECOND search on cursor.

If you need this really, you can try create TMP table,
Then search on it

    CREATE OR REPLACE TABLE tmp_songs
        AS select * from songs where lockout = 0
 
Now you can do searches on this new tmp table.


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