how to pass null parameter to a stored procedure with TAdoStoredProc

Faruk Okcu

Delphi Developer

Sat, 26 Jul 2003 18:02:33 GMT

how to pass null parameter to a stored procedure with TAdoStoredProc

When i pass NULL parameters to a MSSQL stored proc delphi compains
'parameter object is improperly defined...'

any ideas.

Faruk Okc

Delphi Developer

Wed, 30 Jul 2003 04:30:56 GMT

Re:how to pass null parameter to a stored procedure with TAdoStoredProc

Thanks howard i will try.

Quote

"Howard Moon" <hm...@landstar.com> wrote in message

news:95os14$pgl9@bornews.inprise.com...

Quote

> Here's a line from my code:
> (stores NULL in an integer field)
> ADOStoredProcSaveLoad.Parameters.CreateParameter( 'P_Distance',
> ftInteger, pdInput, 0, NULL );
> -Howard

> "Faruk Okcu" <faruko...@yahoo.com> wrote in message

news:3a7fcc2a_2@dnews...

Quote

> > When i pass NULL parameters to a MSSQL stored proc delphi compains
> > 'parameter object is improperly defined...'

> > any ideas.

Other Threads

1. Passing NULL parameters to a stored procedure

2. Passing a null to stored procedure??

3. Passing null values to a stored procedure

4. Stored Procedure - Passing Argument in to a Stored Procedure

5. Passing parameters to stored procedure.

6. Passing blob parameter to stored procedure

7. Delphi2.0 Stored Procedure Parameter passing as LongString

8. passing array as a parameter back to the oracle 8i stored procedure

9. Passing multiple parameters to a stored procedure

10. Passing parameters to Stored Procedure