http://forums.method.me/cs/search/SearchResults.aspx?o=DateDescending&u=5579Search results by user ID 5579en-USCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/p/3113/11875.aspx#11875Wed, 18 Apr 2012 20:44:30 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:11875sbartgis<p>Understandable.</p> <p>Knowing that it is SQL Server helps because now I am able to say &quot;TOP 1000&quot; in the fieldQuery and choose a column to order by I can now range the requests by something other than date - which I don&#39;t like.</p> <p>I suppose since you didn&#39;t offer any alternatives that there is no way to get an entire table in one shot. You may want to update the error message in the online Export tool.</p>http://forums.method.me/cs/forums/p/3113/11854.aspx#11854Tue, 17 Apr 2012 19:25:53 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:11854sbartgis<p>I am trying to retrieve a very large dataset from the system using the MethodAPISelect_DataSetV2. All of the tables I have tried work fine except for one. The query fails after about 60 seconds with an error from the far&nbsp;end web service about web.config needing additional parameter.&nbsp;The table in question is called &quot;Activities.&quot; Even the built-in Export tool on the Method website fails.</p> <p>I can programmatically segment the query into month/year ranges in the strWhereClause, but I would rather perform the select with LIMIT and OFFSET for ranges. Can this be done?<span style="font-family:Consolas;color:#a31515;font-size:x-small;"> <p><font face="Consolas" size="2" color="#a31515"><font face="Consolas" size="2" color="#a31515"></font></font></p> </span></p>