roeya
Posts: 181
|
Posted: 02/14/2008, 8:06 AM |
|
The problem:
When using group by I get "CCS Not count" meesage instead of records count in a grid.
Using group by does not goes well with count(*) because the computer doesn't "know" what you realy need... So I usaully use before execute select to set the CountSQL query,
The solution:
Adding text box to VQB that to let me enter this CountSQL when I use group by will prevent the extra coding and a bonus - Pelease let me run the query in VQB to see if it works as expected (Compare the number of row returned by the query with the number of rows reported by the Count query)
P.S VQB = Visual Query Builder....
_________________
http://www.infoneto.com/ |
|
|
|