ADO Data Shaping with Stored Procedures

[dougcoulter]

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!

 

[dougcoulter]

I stumbled across the solution when searching for the connection strings for Data Shaping. It also showed an example of calling sprocs within the SHAPE command. I forgot the exec statement! Oddly enough, the provider I am using (MSDataShape) did not require it on the parent recordset. Anyway, here is my working statement:

SHAPE {exec stpChemRecPendGet} APPEND ({exec stpChemRecPendDetGet} RELATE BOMMatNum TO BOMMatNum)