Thank you all for responses! 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.
Thanks again, Paul > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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 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 execute it. > On SuperEngine, very often the next user can NOT run it until a > restart of the server is made or the last client disconnected. > > I think this is normal, but I don't know. > I am only using Classic, and I see such problems only where users have > Super engine. This is in any case something that Paul also has to keep > in mind. > > > -- > Mit freundlichen Grüssen, > > André Knappstein, EDV und Controlling > Verwaltungs- und Erlebniszentrum Marina Rünthe > beta Eigenheim GmbH > Hafenweg 4 > 59192 Bergkamen-Rünthe > > Durchwahl: +49 2389 9240 140 > > > > > > ----------------------------------------------------------------------- > -- > 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 ------------------------------------------------------------------------- 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
