How do you run a stored procedure from VB6 to insert a table with a primary key
i.e.
Set Param = cmd.CreateParameter("@primarykey", adVarChar, adParamInput, 200, a)
cmd.Parameters.Append Param
Set Param = cmd.CreateParameter("@create_dttm_3", adDate, adParamInput, , b)
cmd.Parameters.Append Param
I cannot insert it, what am i doing wrong ?
Cheers
GazC
i.e.
Set Param = cmd.CreateParameter("@primarykey", adVarChar, adParamInput, 200, a)
cmd.Parameters.Append Param
Set Param = cmd.CreateParameter("@create_dttm_3", adDate, adParamInput, , b)
cmd.Parameters.Append Param
I cannot insert it, what am i doing wrong ?
Cheers
GazC