Hi Ed
Two items. I cut and pasted your code into a program and ran it. I got a syntax error. The line I was baffled by as this one:
MySQLComm = mSQLFldList + mSQLFldList2 + mSQLFrom + mSQLJoin + mSQLWhere + mSQLOrder
I changed your code from the '&mSQLFldList.... to the one above and it ran fine.
So first you should be concatenating your strings together. Second
if you are passing this string to an ODBC connection you will probably get an error. I hear that SQLExec has probs with strings over 255.
Thanks
Rod
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.