mushin
Programmer
- Oct 4, 2000
- 49
Trying to retrieve datetime's via output parms in sql 7 stored proc.The other parms (varchar/int) work fine.
***** VB code snippet *******
Dim objCmd As New ADODB.Command.....
objCmd.Parameters.Append _
objCmd.CreateParameter("admission_date", adSmallDateTime, adParamOutput).....
*****spoc code snippet **********
CREATE PROCEDURE sel_admission_test
(@pt_id varchar(25),@admission_sequence integer,@last_name varchar(25) output,@first_name varchar(15) output,@admission_date smalldatetime output)
as........
******************?????*************
is "adSmallDateTime" Valid ?
admission_date is defined as smalldatetime.
do I need a length like the others and if so what, I tried 8
cause dates are 8 bytes.....???
I don't do a lot of vb/sql so be mericiful.....
***** VB code snippet *******
Dim objCmd As New ADODB.Command.....
objCmd.Parameters.Append _
objCmd.CreateParameter("admission_date", adSmallDateTime, adParamOutput).....
*****spoc code snippet **********
CREATE PROCEDURE sel_admission_test
(@pt_id varchar(25),@admission_sequence integer,@last_name varchar(25) output,@first_name varchar(15) output,@admission_date smalldatetime output)
as........
******************?????*************
is "adSmallDateTime" Valid ?
admission_date is defined as smalldatetime.
do I need a length like the others and if so what, I tried 8
cause dates are 8 bytes.....???
I don't do a lot of vb/sql so be mericiful.....