empty date field by update

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

Article #2204

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

#2204

From: Francesco
Date: Tue, 14 Oct 2003 19:34

14 lines
1157 bytes


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: <3f8c4fcc@newsgroups.borland.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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,164bd9436963e131,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-10-14 12:37:04 PST
From: "Francesco" <.>
Subject: empty date field by update
Newsgroups: borland.public.cppbuilder.database.ado
User-Agent: XanaNews/1.15.7.4
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 80.182.3.55
Message-ID: <3f8c4fcc@newsgroups.borland.com>
Date: 14 Oct 2003 12:34:36 -0700
X-Trace: newsgroups.borland.com 1066160076 80.182.3.55 (14 Oct 2003 12:34:36 -0700)
Lines: 14
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