When to set Prepared = true

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

Article #4880

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

#4880

From: Matt Jacobs
Date: Fri, 24 Aug 2001 06:39

17 lines
1298 bytes

In my ADO queries and commands, do I need to set 'Prepared = true' if
the query has parameters? I understand prepared queries are more
efficient, but if I just want to execute the query once, will the
parameters collection be filled if I don't prepare the query first?
I'm using BDE style parameters with the colon prefix.

Thanks,

Matt Jacobs



--

My reply-to address is purposely mangled to thwart auto-reply bots. 
Please remove the two leading underscores if you wish to reply via
e-mail.

Technical Details

Message-ID: <3b85f5e5.1283054@forums.inprise.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!xmission!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,2c35ed6da94cb5e6,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-08-23 23:44:59 PST
From: mattja@ix.netcom.com (Matt Jacobs)
Newsgroups: borland.public.cppbuilder.database.ado
Subject: When to set Prepared = true
Date: Fri, 24 Aug 2001 06:39:49 GMT
Reply-To: __mattja@ix.netcom.com
Message-ID: <3b85f5e5.1283054@forums.inprise.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: 24.9.166.132
X-Trace: dnews 998635122 24.9.166.132 (23 Aug 2001 23:38:42 -0700)
Lines: 17
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!xmission!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews