Recent

Author Topic: [SOLVED?] Database Paging  (Read 916 times)

MarkMLl

  • Hero Member
  • *****
  • Posts: 1476
Re: [SOLVED?] Database Paging
« Reply #15 on: October 17, 2020, 09:13:15 am »
If all you're doing is trying to get things in chunks then order by the sequential numeric field and put in an appropriate where clause to control the output. Don't rely on limit by itself.

Alternatively use a cursor etc.

MarkMLl
Turbo Pascal v1 on CCP/M-86, multitasking with LAN and graphics in 128Kb.
Pet hate: people who boast about the size and sophistication of their computer.

pcurtis

  • Sr. Member
  • ****
  • Posts: 354
Re: [SOLVED?] Database Paging
« Reply #16 on: October 17, 2020, 10:18:25 am »
I don't need to get the data in chunks anymore.
Windows 10 / Linux Mint 20
Laz 2.10.0
FPC 3.2.0

MarkMLl

  • Hero Member
  • *****
  • Posts: 1476
Re: [SOLVED?] Database Paging
« Reply #17 on: October 17, 2020, 10:31:25 am »
Suit yourself, but you're the one who gave yourself a problem, you're the one who doesn't know why it went away, and I'm the one telling you it's still lurking :-)

MarkMLl
Turbo Pascal v1 on CCP/M-86, multitasking with LAN and graphics in 128Kb.
Pet hate: people who boast about the size and sophistication of their computer.

 

TinyPortal © 2005-2018