Skip to main content

Posts

Showing posts with the label code to get concatinate range

Concatenating Query range values in form datasource using axapta

By
Taking value in range by concatenating values in form and use of data source in form public void insert_tmpVillage() { QueryBuildDataSource qbds, qbds1, qbdsid, qbdsid1; Query q = new Query(); Query qid = new Query(); QueryBuildLink QueryBuildLink1; QueryBuildLink QueryBuildLink2; queryRun queryRun1; queryRun queryRun2; _BlockVillage _BlockVillage1; str range; QueryBuildRange qbr; Query query; QueryRun qr; ; Office = _Block.Office; TechYear = _Block.Year; Crop = _Block.CropId; season = _Block.Season; if(District.valueStr() != '' && Taluka.valueStr() != '') { qbdsid = qid.addDataSource(tablenum(_Block)); qbdsid.addRange(fieldnum(_Block, Office)).value(Office); qbdsid.addRange(fieldnum(_Block, Year)).value(TechYear); qbdsid.addRange(fieldnum(_Block, CropId)).value(Crop); qbdsid.addRange(fieldnum(_Block, Season)).value(queryValue(season)); qbdsid1 = qbdsid.addDataSource(tablenum(_Bloc...
Read more