> Anyway, 2 query is needed to get the results. 1 to see if SP exist 1 to > run. Best is to have a stored proc or function to give a true or false > result for me.
But how would that function work if not by making a roundtrip to the database? I think Jiri's idea is the best: just try executing it, if you get an exception, recreate it. Dean. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider