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();" > >
