Tabular Database Form Functions with HTML

With the Single-Row Form the recordset did not have Input Text Controls. This has to be taken into consideration here. This is the new includeInTransmittedTable() function with an associated variable:

//variable for row index of the Transmitted table

var indexTT = 0;

//function to include the processed data row to the Transmitted table

function includeInTransmittedTable(Decision)

{

var recordsetRowNo = numberOfRows - 1;

var check = -1; //to check if recordset row has already been edited.

var oldIndexTT;

//When Decision is EDITED first check if the recordset row has already been edited.

if (Decision == "EDITED")

{

recordsetRowNo = index;

check = document.getElementById('Recordset').rows[index].cells[6].innerHTML;

if (check != -1)

{//row has been edited

recordsetRowNo = index;

oldIndexTT = indexTT;

indexTT = check;

}

}

//When Decision is DELETED

if (Decision == "DELETED")

{

recordsetRowNo = index;

}

//insert a blank row if no editing has taken place in the recordset row concerned

if (check == -1)

{

document.getElementById('TransmittedTable').insertRow(indexTT);

}

//insert blank cells and give them the corresponding data of the row you

//have processed from the recordset.

for (j=0;j<6;j++)

{

//insert blank cells if no editing has taken place in the recordset row concerned

if (check == -1)

{

document.getElementById('TransmittedTable').rows[indexTT].insertCell(j);

}

//form the name of the transmitted INPUT element

tName = "T" + indexTT + j;

//form the input text control ID of the recordset

ID = "EI" + recordsetRowNo + j;

document.getElementById(ID).readOnly=true;

document.getElementById('TransmittedTable').rows[indexTT].cells[j].innerHTML = '<input type="text" ' + 'name=' + tName + ' value="'

+ document.getElementById(ID).value

+ '">';

}

//insert additional cell and the content ADDED, DELETED or UPDATED accordingly

if (check == -1)

{

document.getElementById('TransmittedTable').rows[indexTT].insertCell(6);

document.getElementById('TransmittedTable').rows[indexTT].cells[6].innerHTML = '<input type="text" ' + 'name=' + 'T' + indexTT + '6' + ' value="' + Decision + '">';

}

if (check == -1)

{//you had not already edited the recordset row.

//if you are editing for the first time

if (Decision == "EDITED")

{

document.getElementById('Recordset').rows[index].cells[6].innerHTML = indexTT;

}

//The next row index for the Transmitted table is

indexTT+=1;

}

else

{//you had already edited the recordset row so give back the normal indexTT value.

indexTT = oldIndexTT;

}

}