G
Guest
I have an Access 2000 ADP which is a front-end to a SQL Server database. One
table I am using has a VARCHAR column of 8000 characters. Inside the code of
the Access ADP, where I assign a string variable to the SQL table's column,
the resulting value in the SQL table is truncated. It only retains the last
40 characters or so of the string (it is not just cutting off the end, but
rather only keeping the end of the string - which is really strange to me).
I have tried altering the string to be hard-coded to a set of all letter "A"
(just to be sure there is no special character causing a problem), and it
behaves the same way. In my testing, the string variable is only around 800
characters long - not even approaching the max length of the SQL column. I
have determined that if I only assign the left 250 characters of the string
variable to the SQL column, it will commit all 250 characters to the SQL
table. Also, I have put stops in the code to verify the contents and length
of the string variable - and they are correct - before and after the string
variable is assigned to the SQL column.
Here is a code snippet. The 3 "strEMail... = " lines are references to the
SQL columns in the table - they are bound to the Access ADP's form. The one
in question, the last one, shows what I have done to at least capture 250
characters of the variable. If I do not have the "LEFT(" statement there,
that is when the "strEMailBody" column ends up with only the last 40 or so
characters from the contents of the variable "strBody":
strEMailDistList = strEMails
strEMailSubject = strSubject
strEMailBody = Left(strBody, 250)
What could be causing this?
- Thanks,
JRD
table I am using has a VARCHAR column of 8000 characters. Inside the code of
the Access ADP, where I assign a string variable to the SQL table's column,
the resulting value in the SQL table is truncated. It only retains the last
40 characters or so of the string (it is not just cutting off the end, but
rather only keeping the end of the string - which is really strange to me).
I have tried altering the string to be hard-coded to a set of all letter "A"
(just to be sure there is no special character causing a problem), and it
behaves the same way. In my testing, the string variable is only around 800
characters long - not even approaching the max length of the SQL column. I
have determined that if I only assign the left 250 characters of the string
variable to the SQL column, it will commit all 250 characters to the SQL
table. Also, I have put stops in the code to verify the contents and length
of the string variable - and they are correct - before and after the string
variable is assigned to the SQL column.
Here is a code snippet. The 3 "strEMail... = " lines are references to the
SQL columns in the table - they are bound to the Access ADP's form. The one
in question, the last one, shows what I have done to at least capture 250
characters of the variable. If I do not have the "LEFT(" statement there,
that is when the "strEMailBody" column ends up with only the last 40 or so
characters from the contents of the variable "strBody":
strEMailDistList = strEMails
strEMailSubject = strSubject
strEMailBody = Left(strBody, 250)
What could be causing this?
- Thanks,
JRD