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! --
