Hi, Im looking for opinions here rather than actual code.
I am designing an office application to show a clients details, there a number of ways to implement this, I first present a list of clients and the user chooses the particular client and then I show all the clients details about 20 data items on a single form. Currently I do this programmatically using a select query to get a single rows of data and assign them to the control on the Form Load event. When the user changes any control values the user has to click on a Save button to write back the changes to the DB, I programmatically reassign the value from the control back to the dataset row column and run an update query.
Another alternative which I have never used is to bind the client form and controls to the actual client table via the controls setting and then the data will update automatically when the user changes the controls, so no need for the user to save any changes and then using a Record Navigator I can step through each in turn.
Which is best tho, somehow I feel the programming is better as I have more control although it can be tedious to implement, the binding is easier and less time consuming.
What are the advantages of one over the other?
kind regards
I am designing an office application to show a clients details, there a number of ways to implement this, I first present a list of clients and the user chooses the particular client and then I show all the clients details about 20 data items on a single form. Currently I do this programmatically using a select query to get a single rows of data and assign them to the control on the Form Load event. When the user changes any control values the user has to click on a Save button to write back the changes to the DB, I programmatically reassign the value from the control back to the dataset row column and run an update query.
Another alternative which I have never used is to bind the client form and controls to the actual client table via the controls setting and then the data will update automatically when the user changes the controls, so no need for the user to save any changes and then using a Record Navigator I can step through each in turn.
Which is best tho, somehow I feel the programming is better as I have more control although it can be tedious to implement, the binding is easier and less time consuming.
What are the advantages of one over the other?
kind regards