Page Separated Display

Y

yoachan

Member
Hi All!
I'm using OE 10.01B, I want to make a grid to display my data records. So I'm using standart <table> and <tr> - <td> to create rows and column. But the problem is when I need to display data with large amount of records i'm displaying all of the records at the same time. So the browser got not responding for it has to show thousands of records.
So I think the solution is to split my display into several pages, like google n most web based Information System did (Well, actually my friend did).
I did this using a temp table. I save the query result in a temp table, and put additional field to save page number and add an index for field page. So when the user do requery, I clear the temp tabel and fill it with new records. But when the user only change page, i browse the temp table to display the requested page.
What I don't like is I have to wait until the query finished to display even the first page. So my question is does anybody have any idea how to do this in a better and faster way?

Thanks in advanced.
Regards


YoChan
 
Hi yoachan,

In my opinion nobody looks in detail at anything larger then 50 lines. So instead of building up in pages why not just collect the first 50 lines and then put First, Last,Prev and Next buttons in the webpage. Together with some search fields it would be much easier to find data if it is really so much.
And retreiving 50 rows shouldn't take so much time. If I where you I would make a query and keep track of the position if they use F,P,N an L by storing rowids in the session so it's easy to reposition query.

Regards,

Casper.
 
In my opinion nobody looks in detail at anything larger then 50 lines.
Click to expand...
I'm agree with you with this thats why i think i have to put my display into pages. But some times my user needs to display large amount of data such as monthly cash transaction. n they needs to move from first record to 1000th wich is in the middle and so sudden back to 70th record. If I only give them F, P, N, n L, I can't let my user jump for an instant from page 1 to (example) page 12. So i think what i need is F, 1, 2, 3, 4, ..., 10, 20, 30, ... L. Jz confused how to make this come true. or if you have any suggestion, I will be very glad to hear.

And retreiving 50 rows shouldn't take so much time. If I where you I would make a query and keep track of the position if they use F,P,N an L by storing rowids in the session so it's easy to reposition query.
Click to expand...
Is rowid is differ from recid? how can i use them?

Thanks for ur post.

Regards,

YoChan
 
Hi,

Is there any correlation between the 1000th rexcord and the 70th record?
If there is then you should make a more logical (e.g. functional) representation of the data. If there isn't then it's hard to find a good solution for that.

IMO It's not possible to make logic for random search of a set of data.
The best way to solve this, if they don't look at groups of records, is to give the user good search capabilities of the data.

Concerning the other question:
ROWID represents the same as RECID, except RECID is deprecated, so you should use ROWID.
To be more specific RECID is a a four-byte value and ROWID is variable-length byte string.

The RECID function is still around to support backwards compatibility.
But (from online Help)
However, you must use the RECID function for maintaining schema
objects (file and field relationships) in the ABL metaschema files.
Click to expand...

Well that's fine art of deprecating stuff, isn't it :lol:

You could use rowid's with the reposition-to-rowid() method on queries. It helps if you open the query with the indexed-reposition option.


HTH,

Casper.
 
Phew....
It's harder than i thought. But thanks a bunch for ur help. Gives much inspiration :). I'll try the ROWID, see if it'll be working.

Regards

YoChan
 
You must log in or register to reply here.
Back
Top