Re: empty date field by update

Article View: borland.public.cppbuilder.database.ado

Article #2210

Back to borland.public.cppbuilder.database.ado Previous Next

#2210

From: Chip Ling
Date: Wed, 15 Oct 2003 21:51

18 lines
1396 bytes

Does it accept NULL?

Rgds,
Chip Ling

Francesco wrote:

> Hi, i'd like to empty, clear, delete previous value of a date field in
> a MSSQL server 2k table normally I use a query for update and pass the
> new value by parameter but how can I clear it??
>
> ADOQuery1->Close();
> ADOQuery1->SQL->Clear();
> ADOQuery1->SQL->Add("UPDATE TABLE1 SET DATEFIELD = :datefield, ...
> WHERE ....");
> ADOQuery1->Parameters->ParamByName("datefield")->Value = ??;
>
> Thanks in adavance, Francesco

Technical Details

Message-ID: <3F8DC166.9F64E7C7@yahoo.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

References: <3f8c4fcc@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,164bd9436963e131
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-10-15 15:03:39 PST
Message-ID: <3F8DC166.9F64E7C7@yahoo.com>
Date: Wed, 15 Oct 2003 17:51:34 -0400
From: Chip Ling <chip_ling_vb@yahoo.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
To: Francesco <.@yahoo.com>
Subject: Re: empty date field by update
References: <3f8c4fcc@newsgroups.borland.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 204.101.58.41
X-Trace: newsgroups.borland.com 1066254551 204.101.58.41 (15 Oct 2003 14:49:11 -0700)
Lines: 19
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Reply to Parent Message