>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
You're right. we cut out some of the WHERE clauses and it runs. We are substituting * for field names and stuff like that now, but it looks as if there is a limit. We've used really long SQL's before, but not with SQLEXEC.