Board index » delphi » How to set stored proc parameter to NULL ?

Ihor Bobak

Delphi Developer

Sun, 09 May 2004 16:39:07 GMT

How to set stored proc parameter to NULL ?

In BDE there was a way out to perform the %subject% :

spSomeProc.ParamByName('SomeParam').Clear;

How to do the same in ADO?

spSomeADOProc.Parameters.ParamValues['SomeParameter'] := ???? WHAT HERE
????

Other Threads

1. *** Using dataset returnet by a stored proc inside another stored proc ***

2. SQL Server Stored Proc Null Date

3. Passing NULLs in a DBXpress Stored Proc

4. Stored proc not returning values with output parameters

5. MS SQL Server stored proc parameter problem

6. Default Stored Proc/ named parameters

7. Please help -- Stored Proc parameter passing.

8. problem with Oracle stored proc parameters in TADOStoredProc

9. Getting SQL 7 Stored Proc parameters in runtime

10. ADO Stored Proc problem with Parameters