More Database Form Functions with HTML

The addRowToRecordset() function adds a row with the information in the form Input controls to the end of the recordset. It also calls the includeInTransmittedTable('ADDED') function. This function adds the copy of the row added to the recordset to the Transmitted Table. The argument “ADDED” is the value for the last field in the row (copy) of the Transmitted Table.

Remember that if the form starts with an empty recordset, all the navigation buttons are disabled. In this case, while you are adding rows to the recordset, you enable the Show-First and Show-Previous buttons, so that you can navigate back to the rows you have added. So when the number of rows added to the recordset reaches 2, the addRowToRecordset() function enables these buttons.

To understand the details of the addRowToRecordset() function, you need to have basic knowledge in HTML DOM Table object, HTML DOM Row object, and HTML DOM Table Cell object. This is the code of the function:

function addRowToRecordset()

{

//the row is added at the end of the recordset - you can sort afterwards

//insert a blank row at the end of the table

document.getElementById('Recordset').insertRow(numberOfRows - 1);

//form the ID of the new row

rowID = 'TR' + (numberOfRows-1);

//give the new row its ID

document.getElementById('Recordset').rows[numberOfRows - 1].id = rowID;

//insert blank cells, give them IDs and their contents

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

{

//form ID for table cell

RID = "TD" + (numberOfRows - 1) + j;

//form the input text control ID

ID = "EI" + j;

document.getElementById('Recordset').rows[numberOfRows - 1].insertCell(j);

document.getElementById('Recordset').rows[numberOfRows - 1].cells[j].id = RID;

document.getElementById('Recordset').rows[numberOfRows - 1].cells[j].innerHTML = document.getElementById(ID).value;

}

//add the seventh blank cell with the value, -1, which shows that the row has not been edited

document.getElementById('Recordset').rows[numberOfRows - 1].insertCell(6);

document.getElementById('Recordset').rows[numberOfRows - 1].cells[6].innerHTML = "-1";

includeInTransmittedTable('ADDED');

//If numberOfRows is 2, enable showFirstRow and showPreviousRow Buttons since they are still disabled.

if (numberOfRows == 2)

{

enableButtons('SFA1','SP1');

index = 1; //this will be used in setting the row position number

}

}

We continue in the next part of the series.