Retrieve Data only shows 100 records

Retrieve Data only shows 100 records

Postby jcrabtreesla » Tue 12 Sep 2006 13:52

I am importing from an access database. I realized one table was only showing 100 records. So I got into the command line and all 14000 records are there for that table. I assume that there is a restriction to 100 records in the MySQL provider in VS 2005. If so, is there any way to change this to allow for more records to be displayed?
Thanks
jcrabtreesla
 
Posts: 12
Joined: Thu 20 Jul 2006 15:01

Postby Alexey » Tue 12 Sep 2006 15:44

There is no such restriction. Please describe the problem in detail.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Alexey » Tue 12 Sep 2006 16:45

I think i get you. You should change MySqlDataTable.MaxRecords property.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby jcrabtreesla » Tue 12 Sep 2006 18:10

To be more specific so you understand. In the DB explorer when you right click a table and select Retrieve Data, only 100 records are displayed and it says at the bottom 1 of 100. Only this table has over 14,000 records. I want to have the ability to view all of these records in Visual Studio, instead of just 100.

I tried to change the max records property by right clicking the table in the DB Explorer and selecting properties. But the properties window is greyed out and I cannot change this property. It is currently set at 0 (I assume default). Do I have to change this in the directly on the server through the command line or is there a way to do this in the DB Explorer?

Thanks
jcrabtreesla
 
Posts: 12
Joined: Thu 20 Jul 2006 15:01

Postby Alexey » Wed 13 Sep 2006 09:57

There is a combobox on the "Core Lab - Data" tool window. You can type in it any number of records you would like to display.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby jcrabtreesla » Wed 13 Sep 2006 17:53

Found it. Thanks for your help.
jcrabtreesla
 
Posts: 12
Joined: Thu 20 Jul 2006 15:01

Postby Alexey » Thu 14 Sep 2006 06:13

You are welcome.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL