Author Topic: Where did the rest of the notes go?  (Read 3539 times)

SomersetGraham

  • EA User
  • **
  • Posts: 376
  • Karma: +1/-0
    • View Profile
Where did the rest of the notes go?
« on: June 30, 2010, 08:50:26 pm »
Hi all
If you have a note element with a single line of text then this text is stored in the Note column of t_object.
If you have a multiline note element then the first line only appears in t_object.
Anyone know what table the remaining text is stored in

TIA

Graham
Using V12

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13404
  • Karma: +567/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Where did the rest of the notes go?
« Reply #1 on: June 30, 2010, 08:58:22 pm »
Graham,

I think you can only see the first line, but that the column in fact holds the whole note (including line breaks)

Geert

SomersetGraham

  • EA User
  • **
  • Posts: 376
  • Karma: +1/-0
    • View Profile
Re: Where did the rest of the notes go?
« Reply #2 on: June 30, 2010, 09:00:27 pm »
Thanks Geert
I'll look into it

Graham
Using V12

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8607
  • Karma: +257/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Where did the rest of the notes go?
« Reply #3 on: July 01, 2010, 12:45:49 am »
Quote
Graham,

I think you can only see the first line, but that the column in fact holds the whole note (including line breaks)

Geert
Hi Graham,

Geert is absolutely correct.  The Notes columns are MS-Access Memo columns.  If you make the row height greater than 1 line you'll see the rest of the Note.  You can also, after a fashion, scroll within the cell...

HTH,
Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

SomersetGraham

  • EA User
  • **
  • Posts: 376
  • Karma: +1/-0
    • View Profile
Re: Where did the rest of the notes go?
« Reply #4 on: July 01, 2010, 12:58:01 am »
Thanks to all
Using V12