Author Topic: Where is stored value of element.notes in EAObject  (Read 3636 times)

pisokol

  • EA User
  • **
  • Posts: 26
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Where is stored value of element.notes in EAObject
« on: February 03, 2015, 01:47:40 am »
I must write a simply select statement for select notes value sets for element, but...
where is stored this value in EAObjects?

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Where is stored value of element.notes in EAOb
« Reply #1 on: February 03, 2015, 10:56:23 am »
Code: [Select]
SELECT Notes FROM t_object
q.

pisokol

  • EA User
  • **
  • Posts: 26
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Re: Where is stored value of element.notes in EAOb
« Reply #2 on: February 03, 2015, 07:41:06 pm »
tnx :) I tried it first, but... t_object doesn't contains field Notes. It is only Note, but it is empty.

pisokol

  • EA User
  • **
  • Posts: 26
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Re: Where is stored value of element.notes in EAOb
« Reply #3 on: February 03, 2015, 09:30:14 pm »
It's works if the SQL statement is like this
"SELECT Note as Notes FROM t_object".
Without alias "as Notes" it doesn't work correctly, returned empty string.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Where is stored value of element.notes in EAOb
« Reply #4 on: February 03, 2015, 09:49:21 pm »
You should have stated that you run it from EA's search tab :-)

q.

pisokol

  • EA User
  • **
  • Posts: 26
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Re: Where is stored value of element.notes in EAOb
« Reply #5 on: February 03, 2015, 09:57:17 pm »
sorry, of course, its was only for quickly testing in EAModelSearch
tnx