Using ADO - How do I set a Parameter from a VALUE to NULL in Code - Article 184 - go-pugleaf

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

Article #184

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

Using ADO - How do I set a Parameter from a VALUE to NULL in Code

#184

From: Joe L.
Date: Fri, 25 May 2007 15:51

23 lines
1768 bytes

I'm new to ADO and Database programming in C++ Builder.  I'm using the 
C++ Builder Profile in BDS 2006.

I have an application that uses parameters in ADOCommands (created at 
Design Time) to Query Data and Perform inserts into application tables 
in Oracle.  The parameters are set in the code, based on information 
that needs to be inserted into the table.

Some of the parameters have been created, and are set with default 
values at Design time.  These are not touched again in the code.

I've tried:

ADOCommand1->Parameters->ParamByName("FieldName")->Value.Clear();

Before checking to see if there is a value that needs to be set, but the 
parameter doesn't seem to be set to NULL. So once it is set, the value 
propagates into other records, that are supposed to be NULL.

I appreciate any help that you can offer.

Thanks,
Joe

Technical Details

Message-ID: <46570602$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,98e5bfde6924d09f,start
X-Google-Attributes: gid10698b,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Fri, 25 May 2007 11:51:23 -0400
From: "Joe L." <jhlougee@gmail-atnospam.com>
User-Agent: Thunderbird 2.0.0.0 (Windows/20070326)
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Using ADO - How do I set a Parameter from a VALUE to NULL in Code
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 70.16.220.158
Message-ID: <46570602$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1180108290 70.16.220.158 (25 May 2007 08:51:30 -0700)
Lines: 23
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail