Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO Shape command
Message
From
18/11/1998 16:13:17
 
 
To
All
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
ADO Shape command
Miscellaneous
Thread ID:
00158996
Message ID:
00158996
Views:
50
I'm trying to use the data shaping command. I combine APPEND and COMPUTE in order to do grouping of the child table. It works ok unless I pass a parameter from parent table to the child table.

For Example:

SHAPE {SELECT ParentTable.* FROM ParentTable} AS Command1 APPEND (( SHAPE {select *, ? as newField from ChildTable} AS Command2 COMPUTE Command2 BY 'ChildField1') AS Command2_Grouping RELATE 'ParentField1' TO PARAMETER 0,'ParentField2' TO 'ChildField2') AS Command2_Grouping"
Next
Reply
Map
View

Click here to load this message in the networking platform