Retrieve Data only shows 100 records

jcrabtreesla · Post by **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

Alexey · Post by **Alexey** » Tue 12 Sep 2006 15:44

There is no such restriction. Please describe the problem in detail.

Alexey · Post by **Alexey** » Tue 12 Sep 2006 16:45

I think i get you. You should change MySqlDataTable.MaxRecords property.

jcrabtreesla · Post by **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

Alexey · Post by **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.

jcrabtreesla · Post by **jcrabtreesla** » Wed 13 Sep 2006 17:53

Found it. Thanks for your help.

Alexey · Post by **Alexey** » Thu 14 Sep 2006 06:13

You are welcome.