Max allowed text length in a text box within Report section

Comments

• Arhontis Member Posts: 667

  2006-10-27

  1024 is the limit of a text variable, if it is a table field then it is 250.

  Regards,
  Arhontis
  
  https://forum.mibuso.com/search

  0
• DeSp Member Posts: 105

  2006-10-27

  I have a text box in a report section. This text box is sourced from some text variable (Length=1024). When a report tries to display this section Navision crashes. The max allowed length not leading to a system crash for this variable is 404. Is it a normal behavior?

  Nil desperandum

  0
• ssingla Member Posts: 2,973

  2006-10-27

  Dear Friend,
  
  Navision allows 1024 as max length in report and my report is running fine. There must be some other problem.

  CA Sandeep Singla
  http://ssdynamics.co.in

  0
• DeSp Member Posts: 105

  2006-10-27

  Ok, here is what I do:
  
  1. Create a new report with a Customer dataitem (for example).
  2. Fill in the code:

  Customer - OnAfterGetRecord()
  [
   FOR I:=1 TO 405 DO //  I is a Local integer variable
    TextVar[I]:='A';  // TextVar is a Global TEXT (Length=1024) variable
  ]
  

  3. Create a section with a Text Box sourced to a TextVar variable (SourceExpr=TextVar)
  4. Compile, Save and Run a report.
  5. Enjoy your Navision crash (EventType: navisioninternalerror P1: navision P2: 03.70.01.16172 P3: 8 P4: 24)
  
  This issue was reproduced on different clients, different reports, different databases with Navision 3.70A and 3.70B SQL and single user versions.
  
  Any suggestions would be appreciated.

  Nil desperandum

  0
• TonyH Member Posts: 223

  2006-10-27

  I don't have my list of internal errors, but I think your error is either
  
  error 8 in module 24
  or
  error 24 in module 8
  
  Maybe someone else will be able to find the error text before I get back to my other machine and find it for you.
  
  T

  0
• DeSp Member Posts: 105

  2006-10-30

  I guess it is:
  24-8 Internal Errors #Err_MT_RecordTooLong (Module_MT,8 )
  
  But what does it mean?
  
  Have anyone else experienced such a report section TEXT length issue?

  Nil desperandum

  0
• ara3n Member Posts: 9,257

  2006-10-30

  I ran the report in 4.0 sp2 and sp3. No crash. in 3.7 it crashed. So upgrade the executables.

  Ahmed Rashed Amini
  Independent Consultant/Developer
  
  
  blog: https://dynamicsuser.net/nav/b/ara3n

  0
• DeSp Member Posts: 105

  2006-10-30

  Thanks for your help, ara3n.

  Nil desperandum

  0
• ara3n Member Posts: 9,257

  2006-10-30

  you are welcome. I would suggest to move to sp3. It will save you a lot of security issues if you are on sql.

  Ahmed Rashed Amini
  Independent Consultant/Developer
  
  
  blog: https://dynamicsuser.net/nav/b/ara3n

  0