Hi,
I have a stored function created in a postgres database, that function returns an integer value and i want to run that function from VB using ADO.
I used
with vcmd
.CommandType = adCmdStoredProc
.CommandText = "fn_insertdata" 'fn_insertdata is the
name of the function
.Parameters.Append .CreateParameter
("@v_time_change", adInteger, adParamInput)
.execute
end with
vb freeses at this point, and some time windows close the application.
if some one know how to call a stored function with ado and how to retreive the obtain value into a variable. it would be very helpful
fbelghait
I have a stored function created in a postgres database, that function returns an integer value and i want to run that function from VB using ADO.
I used
with vcmd
.CommandType = adCmdStoredProc
.CommandText = "fn_insertdata" 'fn_insertdata is the
name of the function
.Parameters.Append .CreateParameter
("@v_time_change", adInteger, adParamInput)
.execute
end with
vb freeses at this point, and some time windows close the application.
if some one know how to call a stored function with ado and how to retreive the obtain value into a variable. it would be very helpful
fbelghait