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: [email protected] <[email protected]> On Behalf Of Doug Hamilton Sent: November 27, 2018 2:55 PM To: [email protected] 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, [email protected] <mailto:[email protected]> 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: [email protected] <mailto:[email protected]> <mailto:[email protected]> <[email protected]> On Behalf Of Dan Goldberg Sent: November 27, 2018 9:37 AM To: [email protected] <mailto:[email protected]> 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: [email protected] <mailto:[email protected]> <[email protected] <mailto:[email protected]> > On Behalf Of [email protected] <mailto:[email protected]> Sent: Tuesday, November 27, 2018 6:23 AM To: [email protected] <mailto:[email protected]> 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 [email protected] <mailto:[email protected]> . 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 [email protected] <mailto:[email protected]> . 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 [email protected] <mailto:[email protected]> . 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 [email protected] <mailto:[email protected]> . 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
