Thanks everyone,
I kind of did a combination of Albert’s browse command and Bill’s “logic”. I created a SQL view called TRACE_vw and the below SQL select works great: select T1.ROWID, T1.PART_ID, T1. ID, T1.APROPERTY_4 from TRACE T1, TRACE_vw T2 where T1.PART_ID = 'PV216365006R' and T1.PART_ID = T2.PART_ID and T2.ROWID = (T1.ROWID + 1) and T1.ID = T2.APROPERTY_4 Thanks again for everyone’s help, Paul Buckley From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Doug Hamilton Sent: November 27, 2018 2:55 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - SQL Help - OT Is also coincidence that ID1 is less than ID2 in the selected rows? Could that be a SEL criteria? Doug On 11/27/2018 8:48 AM, p...@buckleyandassoc.com <mailto:p...@buckleyandassoc.com> wrote: Dan, Thanks but it’s only coincidental that the sample I created I needed the “odd” rowid’s. My guess is it will be 50/50 odd or even. What I need is to check ID1 & ID2 and if the ID1 from the next row equals the ID2 from the previous row I don’t select that row. Thanks anyway, Paul From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> <mailto:rbase-l@googlegroups.com> <rbase-l@googlegroups.com> On Behalf Of Dan Goldberg Sent: November 27, 2018 9:37 AM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: RE: [RBASE-L] - SQL Help - OT You can do this to get the odd rowid values in rbase. Select ROWID, PART_ID, ID1, ID2 from tablename where (MOD(ROWID,2)) = 1 Dan Goldberg From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > On Behalf Of p...@buckleyandassoc.com <mailto:p...@buckleyandassoc.com> Sent: Tuesday, November 27, 2018 6:23 AM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: [RBASE-L] - SQL Help - OT Good morning, I need some help with a SQL select command, not specifically for R:BASE. See my little table sample below. What I’d like to end up with after the SQL select is the following rows: Results of SQL Select/Query ROWID PART_ID ID1 ID2 1 PV216365006R -00105 -00106 3 PV216365006R -00107 -00108 5 PV216365006R -00109 -00110 7 PV216365006R -00111 -00112 Sample Table to Query ROWID PART_ID ID1 ID2 1 PV216365006R -00105 -00106 2 PV216365006R -00106 -00105 3 PV216365006R -00107 -00108 4 PV216365006R -00108 -00107 5 PV216365006R -00109 -00110 6 PV216365006R -00110 -00109 7 PV216365006R -00111 -00112 8 PV216365006R -00112 -00111 I know how I’d do this in a Declare statement in R:BASE but as I said, it has to be done with a SQL select command. Any blues clues would be greatly appreciated. TIA, Paul Buckley -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon> Virus-free. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link> www.avast.com -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
