More Database Form Functions with HTML
(Page 1 of 6 )
This is the fourth chapter of a thirteen part series regarding the creation of database forms with HTML. In this article we will continue discussing the functions relevant to the development process, including showNextRow(), showLastRow(), showFirstRow(), addRow(), and addRowToRecordset(). Join us as we edge toward completion.
The showNextRow() Function
If the user has just finished typing in the add-mode, the addMode variable would be true. If the user has just finished typing in the edit-mode, the editMode variable would be true. The function first checks if the user was in the add-mode. If he was there, it completes the Add process by calling other functions. Then it sets the add-mode variable to false. It then checks if the user was in the edit-mode. If he was there, it completes the Edit process by calling other functions and setting the edit-mode variable to false. It goes on to display the next row of the recordset. This is the code:
function showNextRow()
{
//add to recordset any data that might have been included in the controls
if (addMode == true)
{
addRowToRecordset();
//after adding, you must go out of the addMode, so reset the addMode variable
addMode = false;
makeReadOnlyInputControls();
//enable the buttons that were disabled in the Add process
enableButtons('E1','D1','F1','So1');
}
//edit any row of the recordset that might have been edited at the form
if (editMode == true)
{
editRowToRecordset();
//after adding, you must go out of the editMode, so reset the editMode variable
editMode = false;
makeReadOnlyInputControls();
//enable the buttons, Edit, Delete, Clear, Find, Sort.
enableButtons('E1','D1','C1','F1','So1');
}
//display the next row
if ((numberOfRows - 1) > index)
{
index+=1; //the next index
for (j=0;j<6;j++)
{
//form the input text control ID
CID = "EI" + j;
//form the recordset ID
RID = "TD" + index + j;
document.getElementById(CID).value = document.getElementById(RID).innerHTML;
//show the data row number
document.getElementById('RowPosition').value = index + 1;
}
}
//disable the showNextRow and showLastRow Buttons if index is (numberOfRows - 1)
if (index == (numberOfRows - 1))
{
disableButtons('SN1','SL1');
}
//enable the showFirstRow and showPreviousRow Buttons if they were disabled
if ((numberOfRows - 1) > index)
{
enableButtons('SFA1','SP1');
}
}
Next: The showPreviousRow() Function >>
More HTML Articles
More By Chrysanthus Forcha
