[sqlite] Re: Find the location of the inserted row according to specific ORDER BY

[Igor Tandetnik]

Ofir Neuman <[EMAIL PROTECTED]> wrote:

I have a table which represent list of files on a specific folder.

TABLE
{
    FileID
    FolderID
    FileName
    FilePath
    CreationDate
    Modified
}

Is there any way i can find the appropriate index (location) of the

new file(row) according to the current ORDER BY?

select count(*) from myTable
where FileName < ?;

(assuming ORDER BY FileName).

Igor Tandetnik

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------