Thanks for reply everyone.
Guys, My bad - summary table and FIMMSummarizationTable is the same table… I apologize for that…
@Martin, @Hari
What are you trying to achieve? // Question from Martin
Problem statement: My form has a grid and a command button. I will write the query in clicked method of command button and it should filter the Grid when clicked on command button
Why are you creating that silly string instead of joining FIMMSummarizationTable with summaryTable and filtering byFIMMWeeklyHour? // Question from Martin
I hope I answered this now
////////////////////////////////////////////////////Please see the code below///////////////////////////////////////////////////////////////////////////////////////////////
Please note that // - anything written after this is explanation of the above line of code
void clicked()
{ // variable decleration
// table deceleration
while select * from summaryTable
where summaryTable.FIMMWeeklyHours > 18
and summaryTable.FIMMWeeklyHours < 25
{
summaryProjId += summaryTable.FIMMCourseProjId + ‘,’ ;
// explaination of the above line of code
// summaryProjId =(“FCM-0066-001”, “FCM-0066-002”,“FCM-0066-003”,) … one comma remains in the end as it is a while loop
}
qrysummaryProjId = subStr(summaryProjId,1,strLen(summaryProjId)-1);
// explaination of the above line of code
// Used substr to remove that last comma remained in the while loop output
qbr2.value(qrysummaryProjId);
// explaination of the above line of code
// So basically qbr.value() is a collection of FIMMCourseProjId
// qbr2.value(“FCM-0066-001”, “FCM-0066-002”,“FCM-0066-003”)
// I want this value to be displayed in the Grid when clicked on command button
FIMMSummarizationTable_ds.executeQuery();
super();
}
init method:
qbr2=this.query().dataSourceName(‘FIMMSummarizationTable’).addRange(fieldNum(FIMMSummarizationTable,FIMMCourseProjId));
This time around I have tried to be as descriptive as I can… I hope everyone will understand my problem statement and explanation of each line of the code… Still if anyone has questions, I will be more than happy to answer
Thanks all in advance for your valuable time
Regards,
Shankar Iyer