>But if cVar is equal or greater than 255, than SQL will receive something like this:
>
>
>exec sp_executesql N'EXEC sp_PaiFilho @P1 ', N'@P1 text', 'XXXXXXXXXXXXXXXX'
>
>In this case the parameter is "text" but the string is truncated to 16 characters only.
>
>Does somebody know why?

Hi Ricardo,

Looks like SQL profiler truncates the string for display purposes.
For the code below, it prints:

exec sp_executesql N'EXEC #TestLongString @P1 ', N'@P1 text', 'AAAAAAAAAAAAAAAA'

But the string is passed without truncation.

CLOSE DATABASES all
CLEAR

SET ALTERNATE TO alternate.txt
SET ALTERNATE ON

?VERSION()
con = SQLCONNECT("LocalServer")

SQLEXEC(con,"create procedure #TestLongString @LongString text as SELECT @LongString as LongString")

LOCAL cLongString

cLongString=REPLICATE("A",500)+"B"
?cLongString,LEN(cLongString)
SQLEXEC(con,"EXEC #TestLongString ?cLongString","result")
cLongString=""
?cLongString
SELECT result
GO top
?
?LongString,LEN(LongString)


SQLDISCONNECT(0)

SET ALTERNATE OFF
SET ALTERNATE TO 
MODIFY COMMAND alternate.txt NOWAIT

return

Result:

Visual FoxPro 08.00.0000.2521 for Windows
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA        501
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
B


AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA        501
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
B

Thanks,
Aleksey.