> 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
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/ | http://
ECTED] On Behalf
> 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
>> 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
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 tr
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
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
Down
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
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.
