Text Data Type - Passing Data

• AndyD

  Old Hand

  Points: 362

  More actions

  February 10, 2003 at 3:45 am

  #357705

  Help Please .....

  I have a stored procedure with a parameter of type text.

  CREATE PROCEDURE SP_LongString @MyString text AS

  Set TextSize 10000

  .........

  From my Vb app I need to pass a string value that may occasionally be greater than 8000 Characters to the SP.

  In my Vb code I set the parameters to pass when I call the Sp ...

  Set parameter(0) = cmd.CreateParameter("@ReturnValue", adParamReturnValue, 4)

  Set parameter(1) = cmd.CreateParameter("@MyString", adVarChar, adParamInput, 10000, sString)

  What data type should I use instead of adVarChar for parameter(1) as this doesn’t work?

  Thanks

  Andy

• February 13, 2003 at 8:00 am

  This was removed by the editor as SPAM