Re: Run Stored procedure - function from VBA

2018-06-19 Thread Łukasz Jarych
t; Bye >> >> -- >> *From:* Rob Sargent >> *Sent:* Wednesday, June 20, 2018 12:54 AM >> *To:* Łukasz Jarych >> *Cc:* pgsql-gene...@postgresql.org >> *Subject:* Re: Run Stored procedure - function from VBA >> >> >>

Re: Run Stored procedure - function from VBA

2018-06-19 Thread Rob Sargent
:00 Asif Ali : >> how the fuck i unsubscribe to this mailing list , i get more than 100 emails >> a day >> >> Bye >> >> >> From: Rob Sargent >> Sent: Wednesday, June 20, 2018 12:54 AM >> To: Łukasz Jarych >> Cc: pgsql-gene...@postgre

Re: Run Stored procedure - function from VBA

2018-06-19 Thread Łukasz Jarych
ent:* Wednesday, June 20, 2018 12:54 AM > *To:* Łukasz Jarych > *Cc:* pgsql-gene...@postgresql.org > *Subject:* Re: Run Stored procedure - function from VBA > > > > > On 06/18/2018 09:51 PM, Łukasz Jarych wrote: > > Thank you Rob, > > question is it is the optimal

Re: Run Stored procedure - function from VBA

2018-06-19 Thread Asif Ali
how the fuck i unsubscribe to this mailing list , i get more than 100 emails a day Bye From: Rob Sargent Sent: Wednesday, June 20, 2018 12:54 AM To: Łukasz Jarych Cc: pgsql-gene...@postgresql.org Subject: Re: Run Stored procedure - function from VBA On 06/18

Re: Run Stored procedure - function from VBA

2018-06-19 Thread Rob Sargent
On 06/18/2018 09:51 PM, Łukasz Jarych wrote: Thank you Rob, question is it is the optimal way to run SP from VBA? Or not? Best, Jacek 2018-06-19 1:34 GMT+02:00 Rob Sargent >: On Jun 18, 2018, at 9:47 AM, Łukasz Jarych mailto:jarys...@gmail.com>> wrote:

Re: Run Stored procedure - function from VBA

2018-06-18 Thread Łukasz Jarych
Thank you Rob, question is it is the optimal way to run SP from VBA? Or not? Best, Jacek 2018-06-19 1:34 GMT+02:00 Rob Sargent : > > > On Jun 18, 2018, at 9:47 AM, Łukasz Jarych wrote: > > Hi Guys, > > i have example function : > > CREATE OR REPLACE FUNCTION totalRecords () > RETURNS integer A

Re: Run Stored procedure - function from VBA

2018-06-18 Thread Rob Sargent
> On Jun 18, 2018, at 9:47 AM, Łukasz Jarych wrote: > > Hi Guys, > > i have example function : > > CREATE OR REPLACE FUNCTION totalRecords () > RETURNS integer AS $total$ > declare > total integer; > BEGIN >SELECT count(*) into total FROM COMPANY; >RETURN total; > END; > $total$

Re: Run Stored procedure - function from VBA

2018-06-18 Thread Rob Sargent
> On Jun 18, 2018, at 9:47 AM, Łukasz Jarych wrote: > > CREATE OR REPLACE FUNCTION totalRecords () > RETURNS integer AS $total$ > declare > total integer; > BEGIN >SELECT count(*) into total FROM COMPANY; >RETURN total; > END; > $total$ LANGUAGE plpgsql;

Run Stored procedure - function from VBA

2018-06-18 Thread Łukasz Jarych
Hi Guys, i have example function : CREATE OR REPLACE FUNCTION totalRecords () RETURNS integer AS $total$ declare total integer; BEGIN SELECT count(*) into total FROM COMPANY; RETURN total; END; $total$ LANGUAGE plpgsql; and i want to run it from VBA using odbc connection. What is the best