Re: NULL Parameters in TADOQuery

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

Article #422

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

#422

From: Clayton Arends
Date: Tue, 21 Nov 2006 23:03

13 lines
1610 bytes

> The problen it's that I can't put a NULL value in a property.
> If I put NULL in a Integer value, it is converted to 0.

I made the same mistake in my post.  Use "Null()" rather than "NULL".

> The q->Parameters->ParseSQL(q->SQL->Text,true); works fine, create all of 
> the params for the q->SQLText query.

Maybe so, but I was trying to point out that this is done by default when 
you alter the SQL property.  Remove the call to ParseSQL() and you will see 
that your code will execute the same.

- Clayton

Technical Details

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

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news.glorb.com!newsgate.cistron.nl!transit.news.xs4all.nl!xs4all!news2.euro.net!213.132.189.2.MISMATCH!multikabel.net!feed20.multikabel.net!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <4561d245$1@newsgroups.borland.com> <4561db48$1@newsgroups.borland.com> <4562ec92$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,ef2115b40e2af41
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Clayton Arends" <nospam_claytonarends@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <4561d245$1@newsgroups.borland.com> <4561db48$1@newsgroups.borland.com> <4562ec92$1@newsgroups.borland.com>
Subject: Re: NULL Parameters in TADOQuery
Date: Tue, 21 Nov 2006 15:03:35 -0800
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 71.83.251.192
Message-ID: <456385b8$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1164150200 71.83.251.192 (21 Nov 2006 15:03:20 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news.glorb.com!newsgate.cistron.nl!transit.news.xs4all.nl!xs4all!news2.euro.net!213.132.189.2.MISMATCH!multikabel.net!feed20.multikabel.net!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message