>
The code is Fox specific, but the SQL it generates is not. However, the SQL is specific to Oracle syntax if that is what you mean. Since SQL Server, MySQL or any other SQL DB is not even on our radar screen where I work, this is a non-issue for me. Anyway, I take a mixture of approaches - ad-hoc SQL generation, RVs, data classes from the client/app, and SPs, Packages, triggers, views, etc., on the server. Just depends on what I need.
>

I hear you...All I am saying is that it is not my preference to do things that would lock me into the fox box. But in your case, you have to make the call.

IMO, Oracle procs - using the utl_file package - to generate sql code files would be a neat way to go if text files is what you wanted. Or...just having the code rendered back to a proc - which would in turn - run the dynamic pl/sql - that too would be cool.

Hey quick question..have you had success with global temp tables??? I miss that feature in sql server...