More Database Form Functions with HTML

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');

}

}