set null as value in date

ghoti
07-13-2006, 06:12 AM
Hi folks,

I'm using a MSDE 2000 database and i was wondering how you can delete a date recordvalue?

if i remember correctly you can't save a null value to the record. But what if the data i have entered wasn't for that field?

let me explain, I have a field BirthDate and a field PresentDate, what if i have by mistake filled in the present date in the birthdate but i want the birthdate to be empty? how can i save an empty date into a datefield so that the old date will be gone and no other date is in its place?

greets ghoti

Topgrob
07-13-2006, 07:45 AM
Not overly up on MSDE but...
Could try
field("DoB").value=Null
??
Or look to see if the field in the database is set to allow nulls?

shettydatta
07-13-2006, 08:37 AM
Hi,
Can you not Update the Date = NULL in Query Analyzer ?


update <tableName>
set BirthDate = NULL
where BirthDate = <value>



Datta

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum