More Database Form Functions with HTML

The main role of this function is to show the previous row.

function showPreviousRow()

{

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

}

if (index > 0)

{

index-=1; //the previous 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 showFirstRow and showPreviousRow Buttons if index is 0

if (index == 0)

{

disableButtons('SFA1','SP1');

}

//enable the showNextRow and showLastRow Buttons if they were disabled

if (index < numberOfRows)

{

enableButtons('SN1','SL1');

}

}