Skip to main content

Posts

Showing posts with the label Taking value in range by concatenating values in form in axapta

Concatenating Query range values in form datasource using axapta

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