RE: [RBASE-L] - SQL Help - OT

2018-11-27 Thread paul
' 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 On Behalf Of Doug Hamilton Sent: November 27, 2018 2:55 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - SQL Help - OT

Re: [RBASE-L] - SQL Help - OT

2018-11-27 Thread Doug Hamilton
* 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> mailto:rbase-l@googlegroups.com>> *

Re: [RBASE-L] - SQL Help - OT

2018-11-27 Thread Albert Berry
> mailto:rbase-l@googlegroups.com>> On Behalf Of Dan > Goldberg > Sent: November 27, 2018 10:09 AM > To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > Subject: RE: [RBASE-L] - SQL Help - OT > > > > Is it only from the previous row

Re: [RBASE-L] - SQL Help - OT

2018-11-27 Thread Bill Downall
evious row. I would sort on the ID1 column so it > would always be the previous row. > > > > Thanks, > > Paul > > > > *From:* rbase-l@googlegroups.com *On Behalf Of > *Dan Goldberg > *Sent:* November 27, 2018 10:09 AM > *To:* rbase-l@googlegroups.com > *

Re: [RBASE-L] - SQL Help - OT

2018-11-27 Thread Albert Berry
The attached RMD will create a database (double quotes) with the one table, load the data you supplied and run a query that returns your results. You can modify the query to suit your needs. Albert -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You

RE: [RBASE-L] - SQL Help - OT

2018-11-27 Thread paul
Dan, It will always be the previous row. I would sort on the ID1 column so it would always be the previous row. Thanks, Paul From: rbase-l@googlegroups.com On Behalf Of Dan Goldberg Sent: November 27, 2018 10:09 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - SQL Help - OT

RE: [RBASE-L] - SQL Help - OT

2018-11-27 Thread Dan Goldberg
Is it only from the previous row or any of the rows? Dan Goldberg From: rbase-l@googlegroups.com On Behalf Of p...@buckleyandassoc.com Sent: Tuesday, November 27, 2018 6:48 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - SQL Help - OT Dan, Thanks but it’s only coincidental

RE: [RBASE-L] - SQL Help - OT

2018-11-27 Thread paul
Paul From: rbase-l@googlegroups.com On Behalf Of Dan Goldberg Sent: November 27, 2018 9:37 AM To: 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))

RE: [RBASE-L] - SQL Help - OT

2018-11-27 Thread Dan Goldberg
: [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

[RBASE-L] - SQL Help - OT

2018-11-27 Thread paul
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