[ZVV]

DAX 2009 + MS SQL:

static void Job3(Args _args)
{
    Query       q = New Query();
    QueryBuildDataSource qbds;
    QueryRun    qr;

    SysDictTable    dictTable = new SysDictTable(tableNum(InventTable));
    int i;
    ;

    qbds = q.addDataSource(tableNum(InventTable));

    for (i=1; i<=100; i++)
    {
        qbds.addSortField(dictTable.fieldCnt2Id(i));
    }

    info(qbds.toString());
    
    qr = New QueryRun(q);
    
    while (qr.next())
    {
        info("In");
        break;
    }
}

PHP код:

Info    Сообщение (22:39:55)    SELECT * FROM InventTable ORDER BY InventTable.ItemGroupId ASC, InventTable.ItemId ASC, InventTable.ItemName ASC, InventTable.ItemType ASC, InventTable.PurchModel ASC, InventTable.Height ASC, InventTable.Width ASC, InventTable.SalesModel ASC, InventTable.CostGroupId ASC, InventTable.ReqGroupId ASC, InventTable.EPCManager ASC, InventTable.PrimaryVendorId ASC, InventTable.NetWeight ASC, InventTable.Depth ASC, InventTable.UnitVolume ASC, InventTable.BOMUnitId ASC, InventTable.ItemPriceToleranceGroupId ASC, InventTable.Density ASC, InventTable.Dimension ASC, InventTable.CostModel ASC, InventTable.UseAltItemId ASC, InventTable.AltItemId ASC, InventTable.Intracode ASC, InventTable.ProdFlushingPrincip ASC, InventTable.MinimumPalletQuantity ASC, InventTable.PBAItemAutoGenerated ASC, InventTable.WMSArrivalHandlingTime ASC, InventTable.BOMManualReceipt ASC, InventTable.StopExplode ASC, InventTable.Phantom ASC, InventTable.IntraUnit ASC, InventTable.BOMLevel ASC, InventTable.BatchNumGroupId ASC, InventTable.AutoReportFinished ASC, InventTable.OrigCountryRegionId ASC, InventTable.StatisticsFactor ASC, InventTable.AltConfigId ASC, InventTable.StandardConfigId ASC, InventTable.ProdPoolId ASC, InventTable.PropertyId ASC, InventTable.ABCTieUp ASC, InventTable.ABCRevenue ASC, InventTable.ABCValue ASC, InventTable.ABCContributionMargin ASC, InventTable.CommissionGroupId ASC, InventTable.Configurable ASC, InventTable.SalesPercentMarkup ASC, InventTable.SalesContributionRatio ASC, InventTable.SalesPriceModelBasic ASC, InventTable.DEL_MinAverageSettle ASC, InventTable.NameAlias ASC, InventTable.ProdGroupId ASC, InventTable.projCategoryId ASC, InventTable.grossDepth ASC, InventTable.grossWidth ASC, InventTable.grossHeight ASC, InventTable.standardPalletQuantity ASC, InventTable.qtyPerLayer ASC, InventTable.sortCode ASC, InventTable.ConfigSimilar ASC, InventTable.SerialNumGroupId ASC, InventTable.DimGroupId ASC, InventTable.ModelGroupId ASC, InventTable.ItemBuyerGroupId ASC, InventTable.TaxPackagingQty ASC, InventTable.WMSPalletTypeId ASC, InventTable.OrigStateId ASC, InventTable.DEL_StopExplodePrice ASC, InventTable.WMSPickingQtyTime ASC, InventTable.TaraWeight ASC, InventTable.PackagingGroupId ASC, InventTable.ScrapVar ASC, InventTable.ScrapConst ASC, InventTable.StandardInventColorId ASC, InventTable.StandardInventSizeId ASC, InventTable.ItemDimCombinationAutoCreate ASC, InventTable.ItemDimCostPrice ASC, InventTable.ItemIdCompany ASC, InventTable.AltInventSizeId ASC, InventTable.AltInventColorId ASC, InventTable.ForecastDMPInclude ASC, InventTable.PalletTagging ASC, InventTable.ItemTaggingLevel ASC, InventTable.FiscalLIFOAvoidCalc ASC, InventTable.FiscalLIFONormalValue ASC, InventTable.FiscalLIFOGroup ASC, InventTable.FiscalLIFONormalValueCalc ASC, InventTable.BOMCalcGroupId ASC, InventTable.PBAItemConfigurable ASC, InventTable.PBAInventItemGroupId ASC, InventTable.PBAHideDialog ASC, InventTable.PBAHideApproval ASC, InventTable.PBAAutoStart ASC, InventTable.PBAMandatoryConfig ASC, InventTable.NRTaxGroup_LV ASC, InventTable.Packing_RU ASC, InventTable.AssetGroupId_RU ASC, InventTable.AssetId_RU ASC, InventTable.IntrastatExclude_LT ASC, InventTable.IntrastatWeight_CZ ASC
Info    Сообщение (22:39:55)    In