Forum Discussion
function fn_StoreClipBoardToTable()
{
// var defaultColumnLine = 0, defaultRowLine = 1;
var txt_clipboard = Sys.Clipboard;
var arr_ClipBoardTxt = txt_clipboard.split("\n");
var columnValues, rowValues,arr_ColumnValues,arr_RowValues;
columnValues = arr_ClipBoardTxt[0];
arr_ColumnValues = columnValues.split("\t");
//Storing Vlaues to Project variable
fn_resetVariable("tbl_CopyToClipBoard");
var tempValue = "";
try
{
Project.Variables.tbl_CopyToClipBoard.RowCount = arr_ClipBoardTxt.length-2;
for(var sI = 0 ; sI < arr_ColumnValues.length ; sI++)
{
var tempCol = aqString.Trim(arr_ColumnValues[sI]);
if(aqString.Find(tempCol,Chr(13),0,false) != -1)
{
tempCol = aqString.Replace(tempCol,Chr(13),"",false);
}
Project.Variables.tbl_CopyToClipBoard.AddColumn(tempCol);
}
for(var cl=1;cl<arr_ClipBoardTxt.length-1;cl++)
{
rowValues = arr_ClipBoardTxt[cl];
arr_RowValues = rowValues.split("\t");
for(var sI = 0 ; sI < arr_ColumnValues.length ; sI++)
{
var tempValue = aqConvert.VarToStr(arr_RowValues[sI]);
if(aqString.Find(tempValue,Chr(13),0,false) != -1)
{
tempValue = aqString.Replace(tempValue,Chr(13),"",false);
}
var tempCol = aqString.Trim(arr_ColumnValues[sI]);
if(aqString.Find(tempCol,Chr(13),0,false) != -1)
{
tempCol = aqString.Replace(tempCol,Chr(13),"",false);
}
Project.Variables.tbl_CopyToClipBoard.$set(tempCol,cl-1,tempValue);
}
}
return true;
}
catch(ex)
{
Log.Error("Error Occured:"+ ex.stack)
}
}On what line in that code does the error generate? Have you tried stepping through?
Also... what is "fn_resetVariable"?
- karthick78 years agoContributor
"fn_resetVariable" - just remove data from table and keeping as empty table variable
Project.Variables.tbl_CopyToClipBoard.$set(tempCol,cl-1,tempValue);
from above line while inserting
tempCol = "release"
tempValue = "3.041S"
i m getting as error as member not found [exception]
- shankar_r8 years agoCommunity Hero
Just now remembered, i was also having same issue later i added additional parameter as "Item" and it worked fine.
Try changing as like below,
Project.Variables.tbl_CopyToClipBoard.$set("Item",tempCol,cl-1,tempValue);- karthick78 years agoContributor
- tristaanogre8 years agoEsteemed Contributor
What it sounds like is that there is no column in your table tbl_CopyToClipBoard with a name of "release". Based upon your earlier post, the column name may actually be "testrelease". Please verify that fn_resetVariable is resetting the table properly (post the code for that if possible).
- tristaanogre8 years agoEsteemed Contributor
I just confirmed what I mentioned. The error as reported means that you're attempting to set the value of a column in the indicated row for which the column in question does not exist.
So... double check tbl_CopyToClipBoard after the fn_resetVariable is called. If it does not contain a "release" column, that's your problem.