The statement should not need the ; because only fox needs this to continue the line--the whole idea is to pass a single string which will execute in the SQL server as a three line command. We use Microsoft SQL7, but the statement should work for any SQL server, since the syntax is ANSI 92 compatible. The chr(13) carriage return character serves as the line break at the SQL server. An example string would be:

"set rowcount 1"+chr(13)+"select * from pubs order by tag"+chr(13)+"set rowcount 0"