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