Depends on the database. Oracle can parse multiline SQL statements, and PL/SQL. For most databases, it's better to call revdb_execute multiple times rather than pass multi-line sql statements. Tuviah Snyder <tuviah at runrev.com> <http://www.runrev.com/> Runtime Revolution Limited - The Solution for Software Development