Karen (and Razzak): Thanks so much for the "group by" tip. It did work and showed me the unique occurrences for the search criteria I entered, as shown below:
R>select xcol, (count(*)) from temp3 group by xcol whe xcol contains "7543" xcol ----------------------------------------------------------------------------- /folder1-14/2014-10-22-xxxx-14-7543-doc001.pdf /folder1-14/2014-10-22-xxxx-14-7543-doc002.pdf /folder1-14/2014-10-22-xxxx-14-7543-doc003.pdf /folder1-14/2014-10-22-xxxx-14-7543-doc004.pdf /folder1-14/2014-10-23-xxxx-14-7543-doc005.pdf The "group by" clause will be a big help in the future, but there are times when I want/need to know how many occurrences there are for certain fields. I don't understand why TALLY in eXtreme 9.5(32) doesn't work the way it always has in my old System5 database (which I've been using for almost 30 years). In other words, in a table where I want to see how many persons' names are associated with certain documents, I should be able to do this: R>tally xcol from temp3 where xcol contains "7543" xcol Number of occurrences ------------------------------------------------- --------------------- /folder1-14/2014-10-22-xxxx-14-7543-doc001.pdf 2 /folder1-14/2014-10-22-xxxx-14-7543-doc002.pdf 3 /folder1-14/2014-10-22-xxxx-14-7543-doc003.pdf 2 /folder1-14/2014-10-22-xxxx-14-7543-doc004.pdf 8 /folder1-14/2014-10-23-xxxx-14-7543-doc005.pdf 2 Instead, I get this: R>tally xcol fro temp3 where xcol contains "7543" xcol Number of Occurrences ---------------------------------------------- --------------------- /folder1-14/2014-10-22-xxxx-14-7543-doc0 15 /folder1-14/2014-10-23-xxxx-14-7543-doc0 2 What I also find interesting is that here, TALLY can discern that there are dates of 2014-10-22 and 2014-10-23. If it can detect that one part of the string (the date) is unique, why can't it detect that the final "docxxx.pdf" parts of the strings are also unique (even if the "doc0..." is truncated in the results)? Perhaps this is just a bug in 9.5(32). If I can't figure out how to make this work, I may have to decide whether it's enough of a bug to make me get 9.5(64), or just wait to see if this is fixed in future updates of 9.5(32). In the meantime, thanks again -- very much -- for the replies (particularly regarding "group by," which I will definitely be using in the future). Patty Original Message: From: Karen Tellef <[email protected]> Reply-To: <[email protected]> To: <[email protected]> Sent: 4/22/2015 11:41:45 AM Subject: [RBASE-L] - Re: TALLY giving unexpected results Patty: I'm just curious if this would work instead. Rather than Tally, does this work from the R> prompt: select xcol, (count(*)) from temp2 group by xcol Karen -----Original Message----- From: Patty Buckingham <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, Apr 22, 2015 1:23 pm Subject: [RBASE-L] - Re: TALLY giving unexpected results An appointment was cancelled, so I had a few extra minutes to try the other suggestions you sent. Unfortunately, I still get incorrect output. Using the Data Browser (R>BROWSE XCOL FROM TEMP2) as you instructed didn't work. It did show the three unique rows in that table, but when I click the column and right-click to select Calculate and then TALLY, I still get 3 occurrences for one value, rather than one occurrence for each of three unique rows: XCOL Number of Occurrences ---------------------------------------------- --------------------- 0000000000000000000000000000000000000000 3 The same thing happens when I tried the instructions you provided in "02." and "03." (re: using the Database Explorer|Table|Open Table...CALCULATE - TALLY). At this point, I'm flummoxed. Even if I don't have 9.5(64), there should be a way to be sure TALLY shows unique rows in 9.5(32). Maybe I am still doing something wrong? Patty Original Message: From: A. Razzak Memon <[email protected]> Reply-To: <[email protected]> To: <[email protected]> Sent: 4/22/2015 10:04:49 AM Subject: [RBASE-L] - Re: TALLY giving unexpected results At 12:21 PM 4/22/2015, Patty Buckingham wrote: >Thank you for the reply. I am new to eXtreme 9.5 and have not >created a startup file >(nor can I find any files in my RBTI folders named *.cfg, if they >exist) so was not >able to edit RBENGINE95_32.CFG. > >The SHOW NAMEWIDTH command didn't work for me: > >R>SHOW NAMEWIDTH >-ERROR- Invalid parameter ( 639) > >I also struck out when trying to SET the namewidth: > >R>SET NAMEWIDTH 60 >-ERROR- This command is currently unsupported in R:BASE V-9 (32-bit) >version . (3222) > >Any other suggestions? Aha ... I didn't know that you are using R:BASE eXtreme 9.5 (32). I wonder why folks are still using 9.5 (32), unless you are stuck and are having difficulties migrating your .RB? databases and applications to 9.5 (64) .RX?, or still using the same .RB? database with R:BASE 9.5 for DOS. For the record, there are sooooooooo many advantages to using R:BASE eXtreme 9.5 (64). http://www.rbase.com/rbg95/compare.php Converting from R:BASE eXtreme 9.5 (32) .RB? to R:BASE eXtreme 9.5 (64) .RX? is as easy as 1-2-3. In any case, NAMEWIDTH setting is eXclusively for R:BASE eXtreme 9.5 (64). With the default installation of R:BASE eXtreme 9.5 (32/64), you may find the R:BASE configuration file under the C:\Windows RBENGINE95_32.CFG RBENGINE95_64.CFG In your specific circumstances, you could use the following options to obtain the correct display of your TALLY command: 01. Use the Data Browser to View the results of TALLY command BROWSE ColumnName FROM TableorViewName WHERE ... Click on the column and then right-click to select Calculate and then TALLY 02. Database Explorer | Tables | Open Table ... Click on the column and then right-click to select Calculate and then TALLY 03. Database Explorer | Tables | Open Table ... Main Menu | Calculate | TALLY .... Hope that helps! Very Best R:egards, Razzak www.rbase.com www.facebook.com/rbase -- 32 years of continuous innovation! 17 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
