Hi
I face with this situation:
Some customers want to have reports or export 'patterns' from fb database.
For that I have some possibilities as sql query or stored procedures. For
query I make all by code. For stored procedures I have 2 situation, first,
SP exist in database, second SP not exist. If SP exist , just run, etc. For
this case it would be useful to have a method to check if SP exist in
database, if not, recreate procedure. (this works only for FB2 I think, for
FB 1.x just create).
Sample code:
FBCommand fbCommand1 = new FBCommand();
fbCommand1.CommandType = CommandType.StoredProcedure;
if (!fbCommand1.Exists) {fbCommand.Recreate()};
What do you think about ???
TIA,
Paul
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
