Lazarus

Programming => Databases => Topic started by: Weitentaaal on March 05, 2021, 09:58:03 am

Title: Get Previous record ?
Post by: Weitentaaal on March 05, 2021, 09:58:03 am: Hello :)

So how do i get the Previous Record of a TSQLQUERY ?
Title: Re: Get Previous record ?
Post by: Leledumbo on March 05, 2021, 11:20:25 am: Quote from: Weitentaaal on March 05, 2021, 09:58:03 am
Hello :)

So how do i get the Previous Record of a TSQLQUERY ?
If there's Next (https://www.freepascal.org/docs-html/fcl/db/tdataset.next.html), there should be Prior (https://www.freepascal.org/docs-html/fcl/db/tdataset.prior.html).
Title: Re: Get Previous record ?
Post by: Weitentaaal on March 05, 2021, 11:24:16 am: 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. :-\
Title: Re: Get Previous record ?
Post by: JuhaManninen on March 05, 2021, 11:29:31 am: Quote from: Weitentaaal on March 05, 2021, 11:24:16 am
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. :-\
You should use code completion. From the list you can guess the right method by its name usually.
Title: Re: Get Previous record ?
Post by: Leledumbo on March 05, 2021, 03:40:58 pm: Quote from: Weitentaaal on March 05, 2021, 11:24:16 am
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. :-\
I guess the name Prior doesn't ring a bell for you, as commonly Next is paired with Prev instead of Prior.
Title: Re: Get Previous record ?
Post by: winni on March 05, 2021, 05:15:46 pm: Quote from: Weitentaaal on March 05, 2021, 11:24:16 am
Guess i just wrote it wrong. :-\

Richard Pryor and SQL are not related!!
Title: Re: Get Previous record ?
Post by: Zvoni on March 08, 2021, 07:56:23 am: Quote from: winni on March 05, 2021, 05:15:46 pm
Quote 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...... :D :D