Click here to Skip to main content
15,894,017 members
Home / Discussions / Database
   

Database

 
QuestionNewbie Question For Sql Installation Pin
cbhkenshin4-Mar-06 1:31
cbhkenshin4-Mar-06 1:31 
AnswerRe: Newbie Question For Sql Installation Pin
Expert Coming4-Mar-06 17:06
Expert Coming4-Mar-06 17:06 
GeneralRe: Newbie Question For Sql Installation Pin
cbhkenshin4-Mar-06 19:51
cbhkenshin4-Mar-06 19:51 
GeneralRe: Newbie Question For Sql Installation Pin
Dave Kreskowiak5-Mar-06 2:13
mveDave Kreskowiak5-Mar-06 2:13 
QuestionThe timeout period elapsed prior to obtaining a connection from the pool Pin
nagarajuepuri4-Mar-06 0:36
nagarajuepuri4-Mar-06 0:36 
QuestionNeed help with ASP.NET website administration tool! - Can't connect to the database when clicked on (AspSqlProvider) test link! Pin
Slow Learner3-Mar-06 9:52
Slow Learner3-Mar-06 9:52 
AnswerRe: Need help with ASP.NET website administration tool! - Can't connect to the database when clicked on (AspSqlProvider) test link! Pin
Slow Learner3-Mar-06 10:13
Slow Learner3-Mar-06 10:13 
QuestionProblem inserting NULL into ORACLE DATE field with ADO Pin
vray3-Mar-06 3:58
vray3-Mar-06 3:58 
Hello.

I'm trying to insert a record into Oracle table via Command.Execute"Insert
Into..Values" query. The table has several DATE fields and some of them have
to have NULL value.
The problem is that when I specify NULL in my insert query, the DATE fields
are getting value of "30-DEC-99" instead of NULL. CHAR fields are getting
NULL value without any issues.
I've tried both Microsoft and Oracle providers with the same result.

Please, let me know what I'm missing or should I use different ways to
achieve what I need (stored procedures or queries w/o values NULL fields).

Thanks


Valeriy Raygorodetskyy
QuestionAccess 2003 number of records Pin
Marc Soleda3-Mar-06 3:49
Marc Soleda3-Mar-06 3:49 
AnswerRe: Access 2003 number of records Pin
Mike Ellison3-Mar-06 6:45
Mike Ellison3-Mar-06 6:45 
Questiongetting notification of changed tables Pin
HotDogM3-Mar-06 1:05
HotDogM3-Mar-06 1:05 
Questionstored procedures Pin
david boon3-Mar-06 0:32
david boon3-Mar-06 0:32 
AnswerRe: stored procedures Pin
Mike Ellison3-Mar-06 6:10
Mike Ellison3-Mar-06 6:10 
QuestionCurrently logged on users? Pin
wasife3-Mar-06 0:07
wasife3-Mar-06 0:07 
AnswerRe: Currently logged on users? Pin
Mike Ellison3-Mar-06 6:34
Mike Ellison3-Mar-06 6:34 
QuestionHow to update a database? Pin
Diego F.2-Mar-06 23:47
Diego F.2-Mar-06 23:47 
AnswerRe: How to update a database? Pin
Paul Conrad3-Mar-06 17:50
professionalPaul Conrad3-Mar-06 17:50 
GeneralRe: How to update a database? Pin
Diego F.3-Mar-06 22:26
Diego F.3-Mar-06 22:26 
GeneralRe: How to update a database? Pin
Paul Conrad4-Mar-06 6:39
professionalPaul Conrad4-Mar-06 6:39 
Questiondollor to rupee conversion. Pin
GBal2-Mar-06 23:06
GBal2-Mar-06 23:06 
QuestionExport data via script Pin
JacquesDP2-Mar-06 17:52
JacquesDP2-Mar-06 17:52 
QuestionDefine SQL Field as Parameter Pin
thedom22-Mar-06 13:10
thedom22-Mar-06 13:10 
AnswerRe: Define SQL Field as Parameter Pin
thedom22-Mar-06 17:24
thedom22-Mar-06 17:24 
GeneralRe: Define SQL Field as Parameter Pin
Colin Angus Mackay2-Mar-06 20:40
Colin Angus Mackay2-Mar-06 20:40 
QuestionDump database to sql??? Pin
code-frog2-Mar-06 11:28
professionalcode-frog2-Mar-06 11:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.