Re: Run Stored procedure - function from VBA - Mailing list pgsql-general

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@gmail.com>:

On Jun 18, 2018, at 9:47 AM, Łukasz Jarych <jaryszek@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();"