0

I have a visual basic 5 project, using Microsfot Remote Data Object 2.0

I have the following code:


Set ps = grdoCon.CreateQuery("Resolucion_ValidaCorrelatividad", SQL)

ps(0).Direction = rdParamReturnValue
ps(1).Direction = rdParamInput

ps.rdoParameters(1) = vbNull

ps.Execute

it gives me the following error:

(40002) 22005: [Microsoft][ODBC SQL Server Driver] Valor de carácter no válido para especificación cast

something like

Invalid character value for cast specificaction...

I've already tried passing "null", vbEmpty, 0, false... but I had no luck...

any idea

Joel Coehoorn
  • 399,467
  • 113
  • 570
  • 794
opensas
  • 60,462
  • 79
  • 252
  • 386

1 Answers1

1

oops, silly me, it was easier than I thought...

just

ps.rdoParameters(1) = Null

...

opensas
  • 60,462
  • 79
  • 252
  • 386