Moving to a specific record in SQLite Table

[Tim_Hare]

@64557:@James Redway

BUT… The code to move to the previous record still does not work.

@64118:@Tim Hare

sql = “select * from Calls where Call < " + X + " order by Call desc limit 1”

Note the use of DESC to reverse the sort.

[James_Redway]

Hi Tim,

Note the use of DESC to reverse the sort.

Thats what happens when you don’t read things completely. I just copied the first line and replaced the “>” with “<” on the second line of code.

Everything works perfectly now. I used Dave’s “=” instead of “< or >” to edit and update the record yet stay on the same record when the table is reloaded. The code is fast and does not get bogged down looping through hundreds of records.

Thank you very much. I really appreciate you taking the time to help.