Re: [Squirrel-sql-users] How to actually remove the 100 rows limit?

[Alexandre P. <Ale...@ei...>]

It is also alias property, so it can be default when you open the alias.

-- 
Alexandre Peshansky, MS
Senior Bioinformatics Analyst, Research Informatics Core (RIC)
Harold & Muriel Block Institute for Clinical & Translational Research at Einstein and Montefiore
Albert Einstein College of Medicine
1300 Morris Park Ave, Block Bldg., Rm 534 Bronx, NY 10461
(718) 430-2440, (914) 457-6792 (office) (201) 970-3530 (cell) - NEW!!!


-----Original Message-----
From: Roger Hill [mailto:rh...@hi...] 
Sent: Thursday, August 11, 2016 4:24 PM
To: KARR, DAVID
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] How to actually remove the 100 rows limit?

In the SQL window, top right hand corner, there is a box that has the number of rows to retrieve. It should say 100. Change it to whatever you want.

Roger
On Thu, August 11, 2016 21:17, KARR, DAVID wrote:
> I have a query where I need to see more than the first 100 rows 
> returned from the query.  I've googled for this, and I've cleared the 
> checkbox in "New Session Properties", and it's cleared in my current 
> session properties, but when I run a query, it still says "Limited to 100 rows".  What am I missing?
****************************************
Roger Hill
****************************************