I'm trying to write a SQL query that will do the following:
Considering a signal with properties (parts in this case, as it's SysML), some of which have properties of their own as embedded elements, I want to output a table such as:
| Field | Description | Data Type | Unit |
Where the Field will be the name of the property, the Description should be the name(s) of the children properties of that property, the Data Type should be the Type of the subproperty, and the Unit should be the stereotype of the subproperty (since I don't know how to grab the "unit" defined in the value types that I'm using).
The SQL is as follows:
select s.Name as Signal, f.Name as Field, p.Name as Description, p.Type as DataType, p.Stereotype as Unit
from t_object as s, t_object as f, t_object as p
where f.ParentID = s.Object_ID and p.ParentID = f.Object_ID
order by s.Name, f.Name, p.Name, p.Type, p.Stereotype
And during document generation I get an error DAO.Database[3061] Too few parameters. Expected 1, and the resulting document is... blank.
Any ideas on what I'm doing wrong here?
