RDCC set me straight....
Here is what they said......
This is not a bug.
When using the correct and current command syntax for the BROWSE command,
the issue should not occur.
BROWSE (MAX(RDATE_)), PATNUMBR, CPTCODE, SERVICE FROM TODO0 GROUP BY
PATNUMBR, CPTCODE, SERVICE
Please note the use of commas in the command syntax.
I was not using the commas correctly.
Now I have a much improved concept of the power of the group by option and how
to use it.
Mike
From: Stephen Markson <[email protected]>
To: [email protected]
Sent: Wednesday, October 14, 2015 2:50 PM
Subject: [RBASE-L] - RE: extracting the most recent data
<!--#yiv1788025443 _filtered #yiv1788025443 {font-family:Helvetica;panose-1:2
11 6 4 2 2 2 2 2 4;} _filtered #yiv1788025443 {font-family:"Cambria
Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv1788025443
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv1788025443
#yiv1788025443 p.yiv1788025443MsoNormal, #yiv1788025443
li.yiv1788025443MsoNormal, #yiv1788025443 div.yiv1788025443MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman", serif;}#yiv1788025443 a:link, #yiv1788025443
span.yiv1788025443MsoHyperlink
{color:blue;text-decoration:underline;}#yiv1788025443 a:visited, #yiv1788025443
span.yiv1788025443MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv1788025443
p.yiv1788025443msonormal, #yiv1788025443 li.yiv1788025443msonormal,
#yiv1788025443 div.yiv1788025443msonormal
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New
Roman", serif;}#yiv1788025443 p.yiv1788025443msochpdefault, #yiv1788025443
li.yiv1788025443msochpdefault, #yiv1788025443 div.yiv1788025443msochpdefault
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New
Roman", serif;}#yiv1788025443 p.yiv1788025443msonormal1, #yiv1788025443
li.yiv1788025443msonormal1, #yiv1788025443 div.yiv1788025443msonormal1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New
Roman", serif;}#yiv1788025443 p.yiv1788025443msochpdefault1, #yiv1788025443
li.yiv1788025443msochpdefault1, #yiv1788025443 div.yiv1788025443msochpdefault1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New
Roman", serif;}#yiv1788025443 span.yiv1788025443msohyperlink {}#yiv1788025443
span.yiv1788025443msohyperlinkfollowed {}#yiv1788025443
span.yiv1788025443msohyperlink1 {}#yiv1788025443
span.yiv1788025443msohyperlinkfollowed1 {}#yiv1788025443
span.yiv1788025443emailstyle171 {}#yiv1788025443 span.yiv1788025443emailstyle27
{}#yiv1788025443 p.yiv1788025443msonormal2, #yiv1788025443
li.yiv1788025443msonormal2, #yiv1788025443 div.yiv1788025443msonormal2
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman", serif;}#yiv1788025443 span.yiv1788025443msohyperlink2
{color:blue;text-decoration:underline;}#yiv1788025443
span.yiv1788025443msohyperlinkfollowed2
{color:purple;text-decoration:underline;}#yiv1788025443
p.yiv1788025443msonormal3, #yiv1788025443 li.yiv1788025443msonormal3,
#yiv1788025443 div.yiv1788025443msonormal3
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New
Roman", serif;}#yiv1788025443 p.yiv1788025443msochpdefault2, #yiv1788025443
li.yiv1788025443msochpdefault2, #yiv1788025443 div.yiv1788025443msochpdefault2
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New
Roman", serif;}#yiv1788025443 p.yiv1788025443msonormal11, #yiv1788025443
li.yiv1788025443msonormal11, #yiv1788025443 div.yiv1788025443msonormal11
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman", serif;}#yiv1788025443 span.yiv1788025443msohyperlink11
{color:#0563C1;text-decoration:underline;}#yiv1788025443
span.yiv1788025443msohyperlinkfollowed11
{color:#954F72;text-decoration:underline;}#yiv1788025443
span.yiv1788025443emailstyle1711 {font-family:"Calibri",
sans-serif;color:#1F497D;}#yiv1788025443 p.yiv1788025443msochpdefault11,
#yiv1788025443 li.yiv1788025443msochpdefault11, #yiv1788025443
div.yiv1788025443msochpdefault11
{margin-right:0cm;margin-left:0cm;font-size:10.0pt;font-family:"Times New
Roman", serif;}#yiv1788025443 span.yiv1788025443emailstyle271
{font-family:"Calibri", sans-serif;color:#1F497D;}#yiv1788025443
span.yiv1788025443EmailStyle38 {font-family:"Calibri",
sans-serif;color:#1F497D;}#yiv1788025443 .yiv1788025443MsoChpDefault
{font-size:10.0pt;} _filtered #yiv1788025443 {margin:72.0pt 72.0pt 72.0pt
72.0pt;}#yiv1788025443 div.yiv1788025443WordSection1 {}-->When I click on the
column head, all the rows disappear This is a bug. Please report it to RDCC.
Is there any way to sort the columns now that I have the data I want? You’ll
need to add an ORDER BY clause for the time being. Regards, Stephen
Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From:
[email protected] [mailto:[email protected]]On Behalf Of Michael J. Sinclair
Sent: October-14-15 2:01 PM
To: Stephen Markson
Subject: [RBASE-L] - RE: extracting the most recent data Ah ha! You rock!!
Is there any way to sort the columns now that I have the data I want? When I
click on the column head, all the rows disappear Mike From: Stephen Markson
<[email protected]>
To: [email protected]
Sent: Wednesday, October 14, 2015 1:56 PM
Subject: [RBASE-L] - RE: extracting the most recent data Get rid of rdate_
in the GROUP BY Regards, Stephen Markson The Pharmacy Examining Board of
Canada 416.979.2431 x251 From:[email protected] [mailto:[email protected]]On
Behalf Of Michael J. Sinclair
Sent: October-14-15 1:43 PM
To: Stephen Markson
Subject: [RBASE-L] - RE: extracting the most recent data Hi Buddy, here is
what i tried bro (max(rdate_)) patnumbr cptcode service from todo0 group by
rdate_ patnumbr cptcode service instead of giving me just the last test, it
gives me every test, as if it is ignoring the MAX function What am I doing
wrong? Mike From: Buddy Walker <[email protected]>
To: [email protected]
Sent: Monday, October 12, 2015 8:54 PM
Subject: [RBASE-L] - RE: extracting the most recent data Mike You could try
SELECT MAX(datecolumn), patientnumber,testcode from sometable group by
patientnumber, testcode, datecolumn Buddy From:[email protected]
[mailto:[email protected]]On Behalf Of Michael J. Sinclair
Sent: Monday, October 12, 2015 8:23 PM
To: [email protected]
Subject: [RBASE-L] - extracting the most recent data Hi all I have a very
long skinny table, 3 columns.
A date, a patient number and test code. I want to extract the rows that are
the most recent test code for each patient. If patient #3000 has had testcode
# 80015 10 times over the last year, then I only want the most recent row for
that testcode/patient combination Is there a single command that can do that?
Mike
