fpSQL and the "index is too big" error

[Richard Veith]

Kenneth,

 

   Thanks for the suggestion.  I set PFSORTSIZE as you suggested and that
did indeed get me past the "index too big" error.  But the results of the
query were pretty odd, as if the SQL grouping wasn't really being done on
the State field.  (I have not had problems with grouping in other, smaller
databases).  For example, for the state of California, the result of the
query contained about 85 rows, repeating CA and Ca multiple times with
different counts for each.  I am trying to determine now if it is something
in my data, or the indexing is messed up.

 

Rich

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20150122/2d41fb71/attachment.html>