Thank you Rob, exactly. Do you know this odbc constructtion?
Best, Jacek 2018-06-20 0:08 GMT+02:00 Asif Ali <asi...@hotmail.com>: > how the fuck i unsubscribe to this mailing list , i get more than 100 > emails a day > > Bye > > ------------------------------ > *From:* Rob Sargent <robjsarg...@gmail.com> > *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/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 <robjsarg...@gmail.com>: > > > > On Jun 18, 2018, at 9:47 AM, Łukasz Jarych <jarys...@gmail.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. >
