... any foreign keys are found this method displays a label in the window that says ***Red text indicates a Foreign Key***. ii) Modify the application with an Update button. I decided that I would just have one update button that was only enabled when a text fields data had been modified. Once the button has been enabled, and clicked, it runs a new method called update(). This method compares the values in each text field with the corresponding data in the rowData vector. If there are any differences, then the method attempts to perform an update query. The update query is created by obtaining data from the findPKConstraint() method. i.e. the where clause is determined by any primary keys the table may have. If the update query is successful, the data in the rowData vector is also updated so that if the user moves between rows the updated value is displayed. If the ...

See this essay or coursework document in full right now