'
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
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>> *
> 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
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
> *
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
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
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
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))
: [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
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
10 matches
Mail list logo