>
>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.
- Jayesh