I just tried and I believe you will get up to 201 rows that match the &vwhere part of the clause.
The same is not true when combining a LIMIT with an ORDER BY. The LIMIT restricts attention to the first set of rows and then the ORDER BY sorts them. Bill Cook Kent WA USA ----- Original Message ----- From: "J.M. GRATIAS" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 5:56 AM Subject: Re: Popup Error Message (Was No Subject) > > Ian : > > >> > Here is a snippet of code which will set you right: > SELECT COUNT(*) INTO vcount &vwhere AND LIMIT = 201 > << > > May I ask a question about your LIMIT clause ? > What is it supposed to do : > > 1) Limit the selection to the first 201 row of the table ? > or > 2) Look thru the entiere table and take only the fisrt 201 row that fit the > WHERE clause ? > > TMHO answer (1) should be the rigth one but now I am not sure anymore .... > > > J.M. GRATIAS, Logimatique > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
