CommandText trop longue !

Question

Hello,

I have an UPDATE  query that is too long and I have got an error message which said that the string is truncated.
Here is my query:

Try
                Dim Fichier As String
                Fichier = CType(Dts.Variables("Utilisateur::FICHIER").Value, String)
                myCommand.CommandText = " UPDATE DTL_CHARG SET FICHIER= '" + Trim(Fichier) + "' WHERE IDCHARGEMENT= '" + Trim(Idchargement.ToString) + "'"
                myReader = myCommand.ExecuteReader()

            Catch ex As Exception
                MsgBox("Erreur UPDATE DTL_CHARG (FICHIER)! Message d'erreur:  " + ex.Message)
            End Try
            myReader.Close()

Fichier is a variable that receives the SSIS variable value (has a string value which is a directory name + a file name, this string is very long and exceed the length limit of the CommandText).

What should I do ?
Thank you for your help

nhervagault · Answer

Hello 

For this problem you can use the ado parameters.

I think that's resolve this.

http://www.knowdotnet.com/articles/dynamicsqlparameters.html

Bye

Renfield · Answer

I just think that you need to grow up the 'FICHIER' field in your database...

Set its size to 255 and you sure won't have this problem

Renfield
Admin CodeS-SourceS- MVP Visual Basic

CommandText trop longue !

2 réponses

Votre réponse

Discussions similaires