>Line 9 is a massive SELECT-SQL statement that is building a temporary table for a report. Its consists of a simple union of two single table selects, with the resulting table having 57 records of 199 fields. Immediately following it are a pair of index commands, which are being skipped along with a bunch of other statements....
>
>I've tried copying it out to another prg, same problem. When I attempted to run it using two distinct SELECTS, it skipped the second completely...
Are you sure that your first SELECT statement doesn't end with a ";", making the next one a comment?