Hi,
I have one temp table. Temp table has two fields, one of type string and the other of real type. The temp table is being populated with data read from another table. I am writing the excel cell in the data in the temp table. Error writing tmp table data to excel. How can I solve this problem…?
code :
//inserted returntmpdata with MyMethod
…
while Select * from returntmpdata
{
cells.item(row,column).value(returntmpdata.Field2);//here is Error with 1
}
ReturnTmptable MyMethod(TransDate _d1,TransDate _d2)
{
TmpTable returnData;
TmpStatistics tmpStatistics;
MYClass myClass;
;
myClass = new MYClass();
tmpStatistics = myClass.execute(_d1,_d2);
// 1
While Select * from tmpStatistics
{
returnData.clear();
returndata.Field1 = tmpStatistics.Field1; // String Type
returndata.Field2 = tmpStatistics.Filed2; // returndata.Field2 Real Type, tmpStatistics.Filed2 Extends Amount
returndata.insert();
}
//2
/*
returnData.clear();
returndata.Field1 = “A”;
returndata.Field2 = 3266140.10;
returndata.insert();
returnData.clear();
returndata.Field1 = “B”;
returndata.Field2 = 6277162.71;
returndata.insert();
returnData.clear();
returndata.Field1 = “C”;
returndata.Field2 = 2903538.40;
returndata.insert();
*/
return returnData;
}