Results 1 to 5 of 5

Thread: DR craches with long text in memo field.

  1. #1

    Default DR craches with long text in memo field.

    Hi Vincent

    We have this report with a memo field in the details section. The more text it holds, the more the report crashes.

    The memo field is 2048 chars, and with just 1000 chars it crashes pretty much always. With 10 chars, almost no crashes.
    I suspect it has something to do with wrapping the text.

    The report is attached if you want to debug it.
    It's the RDS field FAKTURADATA.BESKRIVELSE that gives us trouble.
    It holds the RDS data necessary to run the report.

    Any advice to solve this, or is it a bug in DR?
    Attached Files Attached Files

  2. #2
    Join Date
    Feb 2009
    Posts
    130

    Default Re: DR craches with long text in memo field.

    Hi Jimmy,

    I've looked at your report and you are using a function for the record sort which returns a Memo field. This is not supported and resulted in a memory overwrite and the crash. I've fixed the crash in the next rev. of DR but be advised you still cannot use Memo fields in either groups, record sort or group sort.

  3. #3

    Default Re: DR craches with long text in memo field.

    Hi Ulbe

    Sigh... Thanks for the info. Never would have figured this out myself!
    As a workaround I just made the function return the left 10 chars to sort on. This seems to work. I assume this is legal?

  4. #4
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,869

    Default Re: DR craches with long text in memo field.

    Jimmy,

    Yes as you can sort on the outcome of a function
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  5. #5

    Default Re: DR craches with long text in memo field.

    Great, although I was sorting on a function that returned the content of the whole memo field. I changed it to the 10 left most chars, and it seems to work.

    Thanks both of you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •