Correct URL: http://www.razzak.com/fte (08/03/2000)
----
Alan,
How about "Creating Virtual Auto-Number in Views" and then use the select criteria as you wish.
Take a look at the technical article on Creating Virtual Auto-Number in Views.
From The Edge: Creating Virtual Auto-Number in Views
http://www.razzak.com.fte (08/03/2000)
Hope you find it helpful!
Very Best R:egards,
Razzak.
At 04:25 PM 10/13/2003 -0700, Alan Wolfe wrote:
Nope I didnt know that, it sounds pretty useful though (:
----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 4:18 PM Subject: [RBASE-L] - RE: count with multiple tables
> Alan, > > Did you know that using the R:BASE 7.0 for Windows Report > Designer, you can actually deploy the report on the web > as HTML with the Page xx of xx and have users navigate > through automatically generated report pages with icons, > etc. > > Very Best R:egards, > > Razzak. > > > At 04:07 PM 10/13/2003 -0700, Alan Wolfe wrote: > > >Hey Troy, > > > >Im actualy looking for blocks of 10, like if the user requests page 2 > >i want count >10 and count <=20 to show the results 11-20. > > > >if they request page 3 it would show count >20 and count <=30 to show > >results 21-30. > > > >----- Original Message ----- > >From: <mailto:[EMAIL PROTECTED]>Troy Sosamon > >To: <mailto:[EMAIL PROTECTED]>RBASE-L Mailing List > >Sent: Monday, October 13, 2003 3:55 PM > >Subject: [RBASE-L] - RE: count with multiple tables > > > >I think this would give you unpredictable results. > >I think you might be looking for a group by and a having clause. > > > >select table1.masterId, count (*) from table1 left join table2 on (....) > >group by table1.masterID having count (*) <= 10 > > > >This would give you a list of masterid with 10 or fewer rows in table2. > > > >Troy > > > > > > -----Original Message----- > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Alan Wolfe > >Sent: Monday, October 13, 2003 3:54 PM > >To: RBASE-L Mailing List > >Subject: [RBASE-L] - count with multiple tables > > > >hello i was wondering about using count in selects that involve multiple > >tables. > > > >if i have something like this: > > > >select * from > >table1 left join table2 > >on (clause here) > >and count > 0 > >and count <= 10 > > > >which table does it get the count from? > > > >is it table1, table2 or is it the number of results that it returns? > > > >TIA, > >Alan >
