General information
Category:
Coding, syntax & commands
Hi Rich,
I am going to guess it is a 'run away query' because of the SUM(xinv_trn.QTY) and xinv_trn is not in the group.
VFP 8 is very picky about GROUPs now (got burned myself <g>) and I suspect VFP 5 is more picky than Fox 2.
Try writing the SQL in a more compliant syntax. Sorry no suggestions at this time myself for a rewrite, maybe tomorrow.
HTH,
Cris
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only