>Is it possible to create dynamic SQL on the fly and then >execute. I suppose it wouldn't need to be SQL but could be any fox code. >The true requirement here is that the statement(s) are created and executed >dynamically. >some code ... >would dynamically >INSERT INTO MyTable (fieldA, fieldB) VALUES ('apples', 'bananas') You can put everything in a variable lcSql and execute it with &lcSql.