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
Retrieve Data only shows 100 records
-
- Posts: 12
- Joined: Thu 20 Jul 2006 15:01
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
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