Prepared TADOQuery Question
- From: "Isaac Alexander" <isaacNOSPAM@xxxxxxxxxxxxxxxxxxx>
- Date: Wed, 9 Aug 2006 15:39:54 -0700
I am using Delphi 7 and TADOQuery to attach to my SQL Server 2005.
I have the prepared property set to true, but when using the MS SQL
Profiler, it shows that query gets passed as hardcoded text to a stored
procedure. The profiler results don't change when I open/close the query.
declare @p1 int
set @p1=1
exec sp_prepexec @p1 output,N'@P1 varchar(20)',N'select id, value from table
where value >= @P1 order by value','AREA1'
select @p1
I would have expected something like this for the second call.
exec sp_execute 1, 'AREA2'
Is there any point in using parameterized prepared queries in ADO? Or am I
using the TADOQuery incorrectly?
.
- Follow-Ups:
- Re: Prepared TADOQuery Question
- From: Brian Bushay TeamB
- Re: Prepared TADOQuery Question
- Prev by Date: Re: Error Message "Provider cannot be found, It may not be properly installed."
- Next by Date: Re: Like TClientDataSet.Delta,ADO can only save modified data into stream or file?
- Previous by thread: ADOQuery.DataSet.Locate throws "Unspecified error" on some machines
- Next by thread: Re: Prepared TADOQuery Question
- Index(es):
Relevant Pages
|
