ADO SHAPE COMMAND in ADO.NET

[udayuddanti]

Hi,

I am migrating a code from ADO to ADO.NET. Here i am stuck with the SHAPE statement in sql query that is used in ADO. Please help me out with the equivalent code for ADO.NET



sql= " ((SHAPE { " + sql1+ " } AS SECONDARY APPEND ";
sql= sql+ " ({ " + sql2+ " } AS PROCEDURALSOURCE RELATE 'STASKID' TO 'TASKID') AS PROCEDURALSOURCE, ";
sql= sql+ " ({ " + sql3+ " } AS TASKAREA RELATE 'STASKID' TO 'TASKID') AS TASKAREA, ";
sql= sql+ " ({ " + sql4+ " } AS REPEATS RELATE 'STASKID' TO 'STASKID') AS REPEATS, ";
sql= sql+ " ({ " + sql5+ " } AS SECONDARYUOM RELATE 'STASKID' TO 'TASKID') AS SECONDARYUOM)";
sql= sql+ " AS SECONDARY RELATE 'TASKID' TO 'TASKID') AS SECONDARY";

where sql1, sql2, sql3, sql4, sql5 are complex select statements. It gives an invalid sql statement error in oracle db when i execute this.

It would be great if some one helps me out with equivalent code in ado.net using datasets or some other thing. Thanks.

[TechGnome]

Don't have any Oracle experience, but DB errors like this are pretty much handled the same way:
1) Print out the SQL statement after you have assembled it...
2) Copy it
3) Paste it and run it against your oracle database...
That should help get you closer to where the problem is.

-tg

[dglienna]

Take a look at this. Your syntax doesn't look right:

Set rsLvRecordset = .Execute("SHAPE {SELECT c.CustomerName As Customer, c.CustomerID FROM Customers c ORDER BY c.CustomerName} As Customers" _
& " APPEND ((SHAPE {SELECT oh.OrderNumber As [Order No], oh.CustomerID, oh.OrderHeaderID FROM OrderHeaders oh ORDER BY oh.OrderNumber} As OrderHeaders" _
& " APPEND ({SELECT od.OrderLine As [Line], od.OrderLineDescription As [Description], od.OrderLineQuantity As Quantity, od.OrderHeaderID FROM OrderDetails od ORDER BY od.OrderLine} As OrderDetails" _
& " RELATE OrderHeaderID TO OrderHeaderID))" _
& " RELATE CustomerID TO CustomerID)")

[udayuddanti]

Thanks for the reply.

I am quering all the queries independently to a dataset and creating parent - child relations in datatables. Thanks for the replies