At 08:56 29/01/2002 -0500, J.M. GRATIAS wrote: >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 .... Hi JM
Number 2 is the right answer. Iann >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/
