Is it possible to display a datagrid with Pagination similar to the way this JQUERY DATAGRID works http://www.flexigrid.info/.
If so... Any tips or tutorials on accomplishing this?
Datagrid Pagination
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Datagrid Pagination
Deving on WinVista Home Prem. SP2 32 bit. Using LiveCode 4.6.1 Pro Build 1392
Re: Datagrid Pagination
Well... I figured it out a basic solution for now. Its not quite pagination but... it will work for now. If anyone has a better solution please do share.
My solution involves writing a simple function that limits the records returned.
Example:
Shown below LimitBegin and LimitEnd in my query allows me to limit the number of row I start from and end from to bring into my datagrid.
I simply add a button that when clicked loads the next group of records. LimitBegin and LimitEnd are global variables that
are automatically set with a simple put command... right now it just increments by 25. Below is the basis of the code:
My solution involves writing a simple function that limits the records returned.
Example:
Shown below LimitBegin and LimitEnd in my query allows me to limit the number of row I start from and end from to bring into my datagrid.
I simply add a button that when clicked loads the next group of records. LimitBegin and LimitEnd are global variables that
are automatically set with a simple put command... right now it just increments by 25. Below is the basis of the code:
Code: Select all
put LimitBegin + 25 into LimitEnd
put ("SELECT ID,TITLE FROM products LIMIT " & LimitBegin &","& LimitEnd) into tSQL
put LimitEnd into LimitBegin
Deving on WinVista Home Prem. SP2 32 bit. Using LiveCode 4.6.1 Pro Build 1392