Stored procedures with null arguments

Posts   
 
    
wvnoort
User
Posts: 96
Joined: 06-Jan-2005
# Posted on: 06-Jun-2005 14:46:53   

Is there a way to call a stored procedure where some of the arguments may be null?

I want to call a (retrieval) procedure using the LLBLGen generated adapter code. However, when i add the procedure to the project it generates only methods with for each argument in the stored procedures a corresponding argument. And since most argument are ints, i cannot supply a null value.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 06-Jun-2005 15:56:44   
Frans Bouma | Lead developer LLBLGen Pro
wvnoort
User
Posts: 96
Joined: 06-Jan-2005
# Posted on: 06-Jun-2005 16:35:55   

Shame on me. I should have searched the forum first. flushed

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 06-Jun-2005 16:37:22   

wvnoort wrote:

Shame on me. I should have searched the forum first. flushed

I forgive you, it took me a lot of queries to get the posting. wink . I knew it was there, I couldn't provide the proper search terms. I've now altered the posting so it will turn up with normal searches wink

Frans Bouma | Lead developer LLBLGen Pro