Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #12398

Re: Problem with long character strings

Show all headers | View raw

Am 24.02.2017 um 16:08 schrieb Ron Weiner:
> Patrick Finucane presented the following explanation :
>> On Friday, February 24, 2017 at 9:27:21 AM UTC-5, 
>> internet...@foobox.com wrote:
>>> I am having a problem with handling long character strings, i.e. 
>>> those over 255 characters in length.
>>>
>>> In a table I have a memo field named boq_comment.  In one record it 
>>> contains the value:
>>>
>>> To fine mill the marked area, to remove the HFS surface and then to 
>>> plane 30mm off from the remaining area, removing all waste from the 
>>> site . Cut suitable tie joints, sweep then apply bond coat to the 
>>> surface, overlay the area with 30mm of 6mm SMA surf 40/60 pen 60 PSV 
>>> to levels and cross-falls.
>>>
>>> I can display this in full successfully on a Form even though it is 
>>> 297 characters long.
>>>
>>> I need to access this via a query and when I run that query on its 
>>> own I can see the whole field.
>>>
>>> My problem comes when I access the query in VBA when creating a 
>>> Recordset.
>>>
>>> dim itemRec as DAO.Recordset
>>> set itemRec = Currentdb.openRecordset(“Select * From eDRS_BoQQuery 
>>> Where eDRSID = 1537”)
>>>
>>> I need to assign the particular field to another variable such as in
>>>
>>> x = itemRec(“boq_comment”)
>>>
>>> To check that I am getting the expected value I precede this with
>>>
>>> debug.print  itemRec(“boq_comment”)
>>>
>>> This produces:
>>>
>>> To fine mill the marked area, to remove the HFS surface and then to 
>>> plane 30mm off from the remaining area, removing all waste from the 
>>> site . Cut suitable tie joints, sweep then apply bond coat to the 
>>> surface, overlay the area with 30mm of 6mm SMA surf 4 ?7????? m [ 
>>> ?????7????  ????[ ????      ?
>>>
>>> Strange characters are appearing after 255 characters.
>>>
>>> Why should this happen?  And more particularly how to I overcome this?
>>> (truncating to the first 255 characters would seem to be a cop out)
>>>
>>> Jim
>>
>> I ran a test on my computer.  I have Access 2013.  It works as 
>> expected, I did not get your results.  You don't say what version of 
>> Access you have.  You need to verify the table field is set to LONG 
>> TEXT for something over 255 chars or Memo if Access is prior to 
>> Access 2007.
>
> And here with Access 2007.  I used this code
>
> Public Sub GetMemo()
>    Dim db As DAO.Database, rs As DAO.Recordset
>
>    Set db = CurrentDb()
>    Set rs = db.OpenRecordset("Select * FROM myTable where MyID = 57", 
> dbOpenDynaset)
>    Do While Not rs.EOF
>        Debug.Print Len(rs("mymemo")); rs("mymemo")
>        rs.MoveNext
>    Loop
>    rs.Close
>    Set rs = Nothing
>    Set db = Nothing
>    Exit Sub
> End Sub
>
> Which resulted in this following in the Immediate window.
>
> 297 To fine mill the marked area, to remove the HFS surface and then 
> to plane 30mm off from the remaining area, removing all waste from the 
> site . Cut suitable tie joints, sweep then apply bond coat to the 
> surface, overlay the area with 30mm of 6mm SMA surf 40/60 pen 60 PSV 
> to levels and cross-falls.
Same results with ACC2010. No truncation of the memo field.

Maybe there are some problems with the underlying query you use. What is 
the sql statement of that query?

Ulrich

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Problem with long character strings internet.shopping@foobox.com - 2017-02-24 06:27 -0800
  Re: Problem with long character strings Patrick Finucane <patrickfinucanetx@gmail.com> - 2017-02-24 06:54 -0800
    Re: Problem with long character strings internet.shopping@foobox.com - 2017-02-24 07:07 -0800
      Re: Problem with long character strings Patrick Finucane <patrickfinucanetx@gmail.com> - 2017-02-24 09:06 -0800
        Re: Problem with long character strings Ulrich Möller <knobbi38@arcor.de> - 2017-02-24 18:42 +0100
    Re: Problem with long character strings Ron Weiner <rw@domain.com> - 2017-02-24 10:08 -0500
      Re: Problem with long character strings internet.shopping@foobox.com - 2017-02-24 07:48 -0800
        Re: Problem with long character strings Ron Weiner <rw@domain.com> - 2017-02-24 11:06 -0500
      Re: Problem with long character strings Ulrich Möller <knobbi38@arcor.de> - 2017-02-24 17:14 +0100
        Re: Problem with long character strings internet.shopping@foobox.com - 2017-02-24 09:35 -0800

csiph-web