Information générale
Titre:
SQL output parameter truncated at 255 char
I am calling a SQL stored procedure with an output parameter, which is declared as follows:
CREATE PROCEDURE dbo.PSP_PXGetFilterText
@pPXUserFilterSK uniqueidentifier,
@pFilterText varchar(1000) = '' OUTPUT
AS ...
VFP calls the stored procedure as follows:
lcFilterText = ''
lcSQL = "Exec PSP_PXGetFilterText '" + PXUserFilterSK +"', ?@lcFilterText"
lnRetVal = SQLExec(lnConn, lcSQL)
The stored procedure runs successfully, but lcFilterText only contains the first 255 characters of the output parameter.
Is ODBC truncating to a length of 255?
What can I do to get the full string?
Thanks for the help,
Ted
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement