vicente Posted October 4, 2011 Posted October 4, 2011 Hello, i am using unidbgrid to show the information of one table that it has 100000 records. Well, when i open the table the grid does not reflect the number of pages well. I refresh the grid with the controls of the grid and i use page adv, and page forw. and and first page and last page the number of pages is not correct. for every use of refresh it tell me that i have 1 plus page. If i use Unidbnavigator it works fine. ¿ is this a fail ? Thanks. Quote
Administrators Farshad Mohajeri Posted October 10, 2011 Administrators Posted October 10, 2011 Hello, i am using unidbgrid to show the information of one table that it has 100000 records. Well, when i open the table the grid does not reflect the number of pages well. I refresh the grid with the controls of the grid and i use page adv, and page forw. and and first page and last page the number of pages is not correct. for every use of refresh it tell me that i have 1 plus page. If i use Unidbnavigator it works fine. ¿ is this a fail ? Thanks. What sort of DB engine are you using? Quote
vicente Posted October 10, 2011 Author Posted October 10, 2011 What sort of DB engine are you using? I am using oracle express 10 like dtabase. I use too specific components to access database (www.devart.com) (odac). Thanks. Quote
Administrators Farshad Mohajeri Posted October 12, 2011 Administrators Posted October 12, 2011 Number pages are shown correctly only when DataSet returns a valid RecordCount. Quote
gm3h Posted November 4, 2011 Posted November 4, 2011 I am using oracle express 10 like dtabase. I use too specific components to access database (www.devart.com) (odac). Thanks. I also got the same problem with you. It's a dataset with around 5000 records. I'm using Firebird SQL Server with IBDataset on Delphi XE. Anyway, i got the solution. After opening the dataset, i issue 'dataset.Last' and then 'dataset.First'. Suddenly, the grid showing the right number of page. btw, if using TuniDBNavigator, how to set the default navigation of the TuniDBGrid to only show 'Page x of x' without any navigation ?? Quote
Administrators Farshad Mohajeri Posted November 4, 2011 Administrators Posted November 4, 2011 Well, if anyone can prepare a test case for this it will be highly appreciated. Quote
gm3h Posted November 5, 2011 Posted November 5, 2011 Well, if anyone can prepare a test case for this it will be highly appreciated. ok, gladly.... I attach the small project along with the database. I'm using Delphi XE, Firebird SQL Server version 2.1, and Interbase as the connection. Hope you can fix the bugs. uniGui.zip Quote
Administrators Farshad Mohajeri Posted November 5, 2011 Administrators Posted November 5, 2011 ok, gladly.... I attach the small project along with the database. I'm using Delphi XE, Firebird SQL Server version 2.1, and Interbase as the connection. Hope you can fix the bugs. Thx. As I expected RecordCount value is not consistent. After call to Open, RecordCount is 1. When you call Last it is updated to actual row count. I'll try to find a fix. Logged #1167 Quote
egerardo Posted November 5, 2011 Posted November 5, 2011 The component "uniquery" has QueryRecCount property, if set to True, the example works. Sorry for my English. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.