Unanswered: append recordset returned from a stored procedure
I have a recordset returned from a stored procedure executed in the form open event. Could this recordset append to the form's recordsource property in the form's open event in VB? if so, what's the syntax?
Private Sub Form_Open(Cancel As Integer)
Set add_bag_results = Nothing
.ActiveConnection = CurrentProject.Connection
.CommandType = adCmdStoredProc
.CommandText = "spSampling_add_bag_results"
.Parameters.Append .CreateParameter("ret_val", adInteger, adParamReturnValue)
'.Parameters.Append .CreateParameter("@lotnum", adInteger, adParamInput, 4, rs_add_bag_results(1))
.Parameters.Append .CreateParameter("@lotnum", adInteger, adParamInput, 4, lot_n)
Set rs_add_bag_results = .Execute
I think this is a very insightfull question but your on the wrong forum for this I think. Try Extreme, VB.com, the response is just as quick and it's the same format as this forum. Frankly, I don't know vb but when I had to use it with asp.net I used Extreme vb forum for my code.