Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

datetime as sp output parms

Status
Not open for further replies.

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.....



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top