Follow our news:

Follow canonburysvcs on Twitter Follow Canonbury Services on Facebook Follow Canonbury Services' news by RSS Follow Canonbury Services' news by Atom Follow Canonbury Services' news by email


Groups from SQL queries

29/08/2012 – in Techniques

If, when creating a group from the results of a SQL query, you find that the group doesn’t contain all of the records that you expect, then the explanation will probably be that your query isn’t returning the accountno field.

GoldMine is inconsistent in this regard. Sometimes a group will build happily without the accountno but often it doesn’t – you may get just a few records in the group or none at all.

To be on the safe side, always include the accountno in your list of SELECTed fields if you want to build a group from the results.