Issue with a SQL Query in Document Template editor

[jplusip]

Using a selector, I'm grabbing a stereotyped signal and then trying to generate a table based on its parts. The SQL query is:

select p.Name as Property, p.Notes as Description, v.Name as DataType, u.Value as Unit
from t_object as s, t_object as p, t_object as v, t_objectproperties as u
where p.Parent_ID = s.Object_ID and v.ea_guid = p.PDATA1 and u.Object_ID = p.Object_ID and u.Property = 'unit'
order by p.Name, p.Notes, v.Name, u.Value

Where s should be the signal, p should be its parts, v should be the value type that types the part, and u should be the unit (SysML 1.3 tag).

For some reason I keep getting a DAO error saying there are too few parameters, and then when the document is generated it's blank aside from the line of text I'm using to confirm that the selector is working.

I assume there is something simple I'm missing, but I'm just not catching it.

[qwerty]

It's Note, not Notes.

And ParentID, not Parent_ID.

The order by Note will likely not work (memo).

q.

Orthogonality? What for. Confusion is soooo nice.

[jplusip]

Thanks! That worked. I knew I just needed a second pair of eyes to catch what I was missing!

Also, I got the Parent_ID from Table 2.1.1 from Inside Enterprise Architect. Does that need to be updated, or did I misunderstand it?

[qwerty]

Also, I got the Parent_ID from Table 2.1.1 from Inside Enterprise Architect. Does that need to be updated, or did I misunderstand it?

This has been correct some time ago. Just download the book again from where you did first.

I got fooled by "To underscore or not to underscore. That is the question."

q.