RE: [DUG]Passing date parameters to ADO Stored proc and getting Optio nal feature not implemented

[Cheng Wei (ASL)]

Problem solved. FYI - this is how we get around it:

CREATE PROCEDURE InsertSOShipHeader
  @ShipperID VARCHAR(15),
  @OrdDate VARCHAR(20)
AS
INSERT INTO SOShipHeader (
  ShipperID,
  OrdDate
)
VALUES (
  @ShipperID,
  CAST(@OrdDate AS SMALLDATETIME)
)

CHEERS - Cheng

#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared 
by MailMarshal
For more information please visit www.marshalsoftware.com
#####################################################################################
---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/