Re: [Firebird-net-provider] Order of parameters to stored procedure

[Jiri C. <di...@ci...>]

On 11/15/07, Shreekar Joshi <Shr...@kp...> wrote:
> Thanks for that.
>
> However, since the SP I am trying to execute does not return any values,
> (only insert/update/delete in the SP), select... from SP is not an
> option.

Execute procedure ...

> About getting names and order of parameters from database, is it a good
> idea to cache the SP params and orders at application level (maybe in a
> singleton class hashtable)? This implementation will be in a windows
> forms application and not web based.

In provider? If so, so it's definetely wrong idea. This can bring more
problems than benefits (i.e. altered procedure).

-- 
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com