ExecuteSQL ("SELECT Opus, COUNT ( Opus) FROM BigBase GROUP BY Opus" ; "" ; "")
Returned an error, that is a ?
ExecuteSQL ("SELECT Opus, COUNT (Opus) FROM BigBase GROUP BY Opus" ; "" ; "")
Did you set the calculation result as Text in the field definition?
Also check that the field and table names exactly match what you've used in your file.
My bad, it was a number not a text; however, now the result is the same on all records, ",0"
A comma and a 0.
what do you get when you...
ExecuteSQL ("SELECT Opus FROM BigBase" ; "" ; "")
In this ExecuteSQL ("SELECT Opus, COUNT ( Opus) FROM BigBase GROUP BY Opus" ; "" ; "") the field separator is a comma and the row separator is a carriage return.
Make sure your result field is tall enough to show more than one line or has a scroll bar.
There may be more lines below the result of ",0"
No value, null BUT if I execute ExecuteSQL ("SELECT COUNT (Distinct Opus) FROM BigBase" ; "" ; "") I get 19.
Meaning I have 19 unique records in OPUS, I need to know how many of each of those unique ones there are. One of those 19 is 3 for example, how many 3's I have is the requirement of the report.
Ahhhh crap, it wasn't tall enough!
It shows everything properly now. Is there any chance we can display only the opus count for the opus record selected?
ExecuteSQL ("SELECT COUNT(Opus) FROM BigBase WHERE Opus = ?" ; "" ; "" ; BigBase::Opus )
This should give a count of all Opus that match the Opus of the record.
ExecuteSQL ("SELECT whatever FROM BigBase WHERE the_opus=?" ; "" ; "" ; the_opus)
There should be a special point bonus awarded to people that RTPM (read the poster's mind), because What I want instead is for my field to return the number of times each value in Opus appears sux big time.