Solved

Intraweb DBGrid multi pages

Posted on 2008-10-07
2
1,116 Views
Last Modified: 2013-11-23
I have a query result that I should display it in an Intraweb DBGrid. Can I split the result to be displayed in a multi page. For example maximum is 100, but you can click next to see next 100 and so on.
0
Comment
Question by:Motaz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 21

Accepted Solution

by:
developmentguru earned 500 total points
ID: 22679025
Generally I have seen the page get passed parameters for where it should start displaying records and how many it should display.  This can then be used in the database query (if your database supports it).  SQL Server supports

select top 100 * from MyTable

Inventive use of the select statement may allow you to select just the records you want.  You may need to do a database stored procedure to come up with a list of the IDs that would be in the list of 100 records, then do a select statement where the ID is in the list of returned IDs.

I believe that ADO datasets support paging as well... something else you can look into.
0
 
LVL 7

Author Closing Comment

by:Motaz
ID: 31503810
Very nice idea, thanks, but it will hide for me real records (Total). Anyway I can call two different queries to know Total, and how many pages.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question