Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Passing a NULL date into a stored procedure
Message
De
05/09/2007 17:26:34
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
05/09/2007 11:24:13
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Versions des environnements
Environment:
VB 8.0
Divers
Thread ID:
01252330
Message ID:
01252604
Vues:
14
>>>I am getting a StrongTypingException when I try to pass a NULL date into my SPROC. What is the preferred way of doing this? I know I can set the default value in the SPROC and just not pass the parm, but is there a way to specifically pass a NULL date?
>>>
>>>Thanks!
>>
>>dim myDate as Nullable(of DateTime)
>>
>>should work in VB but I'm not sure.
>>
>>Cetin
>
>So I can pass a nullable datetime variable as a parameter into my SPROC?

Probably we two are thinking of very different things saying SPROC. Actually I don't know what SPROC means and assumed it was a method wrapping calls to SQL server stored procedures. If so then yes. Otherwise not populating it at all would default to null.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform