Re: Order By clause in the Shape command

Matt Faus — Tue, 05 Feb 2008 03:56:07 GMT

Hi Steve,

Here's the solution:

command += "{select * ";

command += "from ";

command += "[LaborSummary] as [LaborSummary] ";

command += "where (LaborSummary.[CA1] = '" + ca1Prefix + "')} ";

command += "append "; command += "({select * ";

command += "from "; command += "[DistributedRecords] as [DistributedRecords] ";

command += "order by DistributedRecords.[CA1], DistributedRecords.[BE], DistributedRecords.[DATE] ";

command += " } relate [CA1] to [CA1]) as [DistributedRecords],";

command += "({select * ";

command += "from ";

command += "[LaborNonLaborComments] as [LaborNonLaborComments]} ";

command += "relate [CA1] to [CA1]) as [LaborNonLaborComments], ";

command += "({select * ";

command += "from ";

command += "[RisksOppsComments] as [RisksOppsComments]} ";

command += "relate [CA1] to [CA1]) as [RisksOppsComments] ";

Order By clause in the Shape command

m181354 — Mon, 04 Feb 2008 19:50:30 GMT

I am getting an error on the Order By clause. Does anyone know the correct syntax?

command += "{select * ";

command += "from ";

command += "[LaborSummary] as [LaborSummary] ";

command += "where (LaborSummary.[CA1] = '" + ca1Prefix + "')} ";

command += "append "; command += "({select * ";

command += "from "; command += "[DistributedRecords] as [DistributedRecords]}";

command += "relate [CA1] to [CA1]) as [DistributedRecords],";

command += "({select * ";

command += "from ";

command += "[LaborNonLaborComments] as [LaborNonLaborComments]} ";

command += "relate [CA1] to [CA1]) as [LaborNonLaborComments], ";

command += "({select * ";

command += "from ";

command += "[RisksOppsComments] as [RisksOppsComments]} ";

command += "relate [CA1] to [CA1]) as [RisksOppsComments] ";

command += "order by DistributedRecords.[CA1], DistributedRecords.[BE], DistributedRecords.[DATE]";