Very Computer

1. SHAPE Command and Stored Procs

If anyone has experience with using SPs instead of SELECT statements with
data shaping, I would appreciate some advice.

This works:
SHAPE {EXECUTE spProductObjectList 1} AS VLObjects
APPEND ({EXECUTE spProductPropValueList 1, 1} AS VLProperties
RELATE 'ID' TO 'OwnerID',
                 'TypeID' TO 'TypeID') AS VLProperty

This does not.
SHAPE {EXECUTE spProductObjectList 1} AS VLObjects
APPEND ({EXECUTE spProductPropValueList ?, ?} AS VLProperties
RELATE 'ID' TO PARAMETER 0,
                'TypeID' TO PARAMETER 1) AS VLProperty

Any comments or suggestions would be appreciated.  I would prefer that you

newsgroup.

Thanks in advance,

Jeff Jones

2. Restore problem

3. Returning a shaped ADO.Recordset using Stored Procs

4. update/insert statement

5. Deploying DB

6. SHAPE problem with Stored Procs in SQL Server

7. Copy data in MYSQL

8. Using Stored Procs w/ Data Shaping

9. Use Stored Procs In Data Shaping?

10. Using SHAPE Command in Stored Procedure

11. ADO Shape command with stored procedure