Stored Procedure question

Posts   
 
    
mafti
User
Posts: 38
Joined: 27-Oct-2004
# Posted on: 22-Feb-2005 13:56:04   

Hi there,

i'm using selfservicing and sqlserver

my stored-proicedure look likes this:


CREATE PROC dbo.usp_fooMethod (@fooID INT, @barID INT = NULL) 
....

when generating i only have the methods where i need to fill in fooID and barID

i cannot use DBNull in my code, because it expects an Integer

how do i do this???

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 22-Feb-2005 14:26:11   

passing NULL to procs via proc parameters is not supported, unfortunately.

Frans Bouma | Lead developer LLBLGen Pro