More Database Form Functions with HTML

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

}