John W. Colby
jcolby at colbyconsulting.com
Tue Mar 4 16:42:01 CST 2003
I just had a fascinating idea. I do a lot of building up of SQL Strings then executing them in A2K. Would it be possible to build a stored procedure where the parameter passed in is the SQL statement to be executed? IOW, do the same thing we do now, manually build a SQL string with the actual values of controls in where clauses etc., then pass that string to a stored procedure and have the stored procedure execute the SQL string and hand back the data? John W. Colby Colby Consulting www.ColbyConsulting.com I've stopped 9,257 spam messages. You can too! Get your free, safe spam protection at http://www.cloudmark.com/spamnetsig/ ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com