>
>Sorry but I don't get your response..What is your question?
>
>
>I do not use CA, but i see a text output parameter compared with a numerical field.
>
>Then the string that CA build is not correct.
>
>

>declare @P1 int
>set @P1=-1
>exec sp_prepare @P1 output,       <===== P1 is declared OUTPUT, you use a @ prefix ?
>N'@P1 text',                      <===== P1 is declared text !
>N'SELECT  tblTest.ID,
>tblTest.TextField1, tblTest.TextField2, FROM tblTest
>WHERE tblTest.SegmentID = @P1 ', 1  <===== P1 text is compared
>select @P1 <===== P1 output
>

>
>Fabio

I do not have control over creating any of these statements. I got it from SQL Profiler and VFP sends it behind the scene when I execute my SQL.