Page 1 of 1

Retrieve Data only shows 100 records

Posted: Tue 12 Sep 2006 13:52
by jcrabtreesla
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

Posted: Tue 12 Sep 2006 15:44
by Alexey
There is no such restriction. Please describe the problem in detail.

Posted: Tue 12 Sep 2006 16:45
by Alexey
I think i get you. You should change MySqlDataTable.MaxRecords property.

Posted: Tue 12 Sep 2006 18:10
by jcrabtreesla
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

Posted: Wed 13 Sep 2006 09:57
by Alexey
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.

Posted: Wed 13 Sep 2006 17:53
by jcrabtreesla
Found it. Thanks for your help.

Posted: Thu 14 Sep 2006 06:13
by Alexey
You are welcome.