From: | Łukasz Jarych <jaryszek(at)gmail(dot)com> |
---|---|
To: | Rob Sargent <robjsargent(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Run Stored procedure - function from VBA |
Date: | 2018-06-20 04:39:15 |
Message-ID: | CAGv31ocD=J=T7VW5YMQt54rXRUHnkn0=fi6LgUWRSfFhZ2Tmzw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you Rob,
exactly. Do you know this odbc constructtion?
Best,
Jacek
2018-06-20 0:08 GMT+02:00 Asif Ali <asif2k(at)hotmail(dot)com>:
> how the fuck i unsubscribe to this mailing list , i get more than 100
> emails a day
>
> Bye
>
> ------------------------------
> *From:* Rob Sargent <robjsargent(at)gmail(dot)com>
> *Sent:* Wednesday, June 20, 2018 12:54 AM
> *To:* Łukasz Jarych
> *Cc:* pgsql-general(at)postgresql(dot)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 way to run SP from VBA?
> Or not?
>
> Best,
> Jacek
>
> 2018-06-19 1:34 GMT+02:00 Rob Sargent <robjsargent(at)gmail(dot)com>:
>
>
>
> On Jun 18, 2018, at 9:47 AM, Łukasz Jarych <jaryszek(at)gmail(dot)com> 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$ LANGUAGE plpgsql;
>
> and i want to run it from VBA using odbc connection.
>
> What is the best way to use it ?
>
> something like this:
>
> Dim dbCon as new ADODB.Connection
> Dim rst as new ADODB.Recordset
>
> Dbcon.connectionstring=”Your connection string goes here!”
> Dbcon.open
>
> Rst.open strsql
>
> where strsql is "Select * from totalRecords" or this is not a good
> solution?
>
> Best,
> Jacek
>
>
> You need the parentheses after the function name: “select * from
> totalrecords();"
>
>
>
> Depends on the usage pattern. I'm sure there is an ODBC construct for
> stored procedures/function, which you could build once and re-use with new
> parameter values if you're going to call this repeatedly.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2018-06-20 05:41:46 | Re: Run Stored procedure - function from VBA |
Previous Message | Michael Paquier | 2018-06-20 03:38:00 | Re: using pg_basebackup for point in time recovery |