Get Previous record ? lazarus / 16-Databases ---------------------------------------------------------------------- Weitentaaal · 2021-03-05 08:58 Hello So how do i get the Previous Record of a TSQLQUERY ? ---------------------------------------------------------------------- Leledumbo · 2021-03-05 10:20 Quote from: Weitentaaal on March 05, 2021, 09:58:03 amHello So how do i get the Previous Record of a TSQLQUERY ? If there's Next, there should be Prior. ---------------------------------------------------------------------- Weitentaaal · 2021-03-05 10:24 Thanks, was looking for this before i Posted this but didn't found anything. Tried again and Found it. Guess i just wrote it wrong. ---------------------------------------------------------------------- JuhaManninen · 2021-03-05 10:29 Quote from: Weitentaaal on March 05, 2021, 11:24:16 amThanks, was looking for this before i Posted this but didn't found anything. Tried again and Found it. Guess i just wrote it wrong. You should use code completion. From the list you can guess the right method by its name usually. ---------------------------------------------------------------------- Leledumbo · 2021-03-05 14:40 Quote from: Weitentaaal on March 05, 2021, 11:24:16 amThanks, was looking for this before i Posted this but didn't found anything. Tried again and Found it. Guess i just wrote it wrong. I guess the name Prior doesn't ring a bell for you, as commonly Next is paired with Prev instead of Prior. ---------------------------------------------------------------------- winni · 2021-03-05 16:15 Quote from: Weitentaaal on March 05, 2021, 11:24:16 am Guess i just wrote it wrong. Richard Pryor and SQL are not related!! ---------------------------------------------------------------------- Zvoni · 2021-03-08 06:56 Quote from: winni on March 05, 2021, 05:15:46 pmQuote from: Weitentaaal on March 05, 2021, 11:24:16 am Guess i just wrote it wrong. Richard Pryor and SQL are not related!! Really?? Superman 3 could have fooled me......