Re: [GENERAL] ADO adCmdStoredProc PlPgSql-SP Parameters

2005-02-11 Thread Jeff Eckermann
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > How do I call a StoredProcdure, written in PlPqSql > which returns a set of records (or tableWhatever) > and wants parameters, > from ADO while using "adCmdStoredProc" ? I don't believe that works (anyone who thinks I'm wrong,

Re: [GENERAL] ADO adCmdStoredProc PlPgSql-SP Parameters

2005-02-11 Thread Postgre . News . Firma
>>Von: Duffner > Von: Shachar Shemesh > Betreff: Re: [GENERAL] ADO adCmdStoredProc PlPgSql-SP Parameters > >How do I call a StoredProcdure, written in PlPqSql > >which returns a set of records (or tableWhatever) > >and wants parameters, > >from ADO while using

Re: [GENERAL] ADO adCmdStoredProc PlPgSql-SP Parameters

2005-02-09 Thread Shachar Shemesh
[EMAIL PROTECTED] wrote: Hi, How do I call a StoredProcdure, written in PlPqSql which returns a set of records (or tableWhatever) and wants parameters, from ADO while using "adCmdStoredProc" ? Which driver are you using? If it's the OLE DB provider, then there is a solution, provided that you

[GENERAL] ADO adCmdStoredProc PlPgSql-SP Parameters

2005-02-03 Thread Postgre . News . Firma
Hi, How do I call a StoredProcdure, written in PlPqSql which returns a set of records (or tableWhatever) and wants parameters, from ADO while using "adCmdStoredProc" ? ERROR: set-valued function called in context that cannot accept a set -- VERY LONG VERSION OF THIS QUEST