On Thu, 21 Nov 2002 06:11:04 -0800 (PST), Dennis McGrath wrote: >rue. The view should probably be created with a variable where >clause. > >WHERE AddressID = (.vAddressID) and NumberID <= (.vNumber) > >if the variables are parenthesized, the view will retain the above >syntax and all you have to do is create the two variables and say >LBLPRINT MultiLable
Still better is: WHERE (AddressID = .vAddressID) AND (NumberID <= .vNumber) Then indexes will be used for each table. Your way the address will be found sequentially. What Dennis means about "retaining the syntax" is that with no parentheses at all, the view would store the value of vAddressID at the time the view was created, as in WHERE addressid = 3592 AND NumberID <= 30 Bill ================================================ 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/
