More Database Form Functions with HTML - The showFirstRow() Function
(Page 4 of 6 )
This function takes you, the user, to the first row when you are at a different row. This function is different from the setFirstRow() function. When you are at a row that is not the first row, going back to the first row takes into consideration certain things that are not taken into consideration when the web page is first opened. So the showFirstRow() function has to be different from the setFirstRow() function.
The code is:
function showFirstRow()
{
//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 disabed 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');
}
//show the first row
index = 0; //First index in array
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 showFirstRow and showPreviousRow Buttons
disableButtons('SFA1','SP1')
//enable the showNextRow and showLastRow Buttons if the recordset has more than one row
if (numberOfRows > 1)
enableButtons('SN1','SL1');
}
Next: The addRow() function >>
More HTML Articles
More By Chrysanthus Forcha
