Paul,
I still did not find a way to reply to this mail-list thingy from
behind our proxy, so I hope this message will get through to you.
The function you wish for does not belong into a command-feature or
new method, but you can easily implement it yourself.
To do that, connect with sufficient
On 6/27/07, André Knappstein, Controlling [EMAIL PROTECTED] wrote:
You can hand the procedure name in question to that query and if you
receive a result, then a procedure with the same name exists in the
database.
Maybe it's better to try to run it and catch exception. You will save
one trip
In addition I think I remember that only with classic server engine a
listed stored proc is active already for the next connection to the
database.
JC What do you mean with listed?
If I create a new SP, I will find it then listed in RDB$Procedures.
On ClassicEngine, next user will be able to
Of André Knappstein, Controlling
Sent: Wednesday, June 27, 2007 11:59 AM
To: Jiri Cincura
Cc: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Enhacement for FBCommand
In addition I think I remember that only with classic server engine
On 6/27/07, Mercea Paul [EMAIL PROTECTED] wrote:
Anyway, 2 query is needed to get the results. 1 to see if SP exist 1 to run.
Just run SP and if you get erorr thst not exists do some steps to fix error.
If exists, you save 1 trip.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ |
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,
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
On 6/26/07, Mercea Paul [EMAIL PROTECTED] wrote:
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).
Hello:
How can FBCommand (re)create procedure? FBCommand has no idea about
internal code of procedure.
And anyway that shouldn't be responsability of the provider ...
-
This SF.net email is sponsored by DB2 Express