dougcoulter
Programmer
Hello all - I am at wits end with a pretty simple data shaping application.
I have two tables related to one another (standard one to many relationship between parent and child). I am trying create a data shape to populate the hierarchical flex grid. I am able to get the desired shape when I just use select statements in the shape statement, but when I shift to stored procedures I keep receiving sytax errors - specifically with the child stored procedure. Here is a sample of my statement:
SHAPE {stpChemRecPendGet} APPEND ({stpChemRecPendDetGet} RELATE BOMMatNum TO BOMMatNum)
I have been able to substitute my select statement from the child stored procedure into this statement, and everything works - so I am comfortable that my sprocs are ok.
Am I missing something simple here? I have been staring at this for about 2 hours now!
I have two tables related to one another (standard one to many relationship between parent and child). I am trying create a data shape to populate the hierarchical flex grid. I am able to get the desired shape when I just use select statements in the shape statement, but when I shift to stored procedures I keep receiving sytax errors - specifically with the child stored procedure. Here is a sample of my statement:
SHAPE {stpChemRecPendGet} APPEND ({stpChemRecPendDetGet} RELATE BOMMatNum TO BOMMatNum)
I have been able to substitute my select statement from the child stored procedure into this statement, and everything works - so I am comfortable that my sprocs are ok.
Am I missing something simple here? I have been staring at this for about 2 hours now!