Question: Ullowing the form in Figure 6.23 statement will be issued nd uted FROM customer MERE cust id = .1012'; e ch om Zach to Zachary
Ullowing the form in Figure 6.23 statement will be issued nd uted FROM customer MERE cust id = .1012'; e ch om Zach to Zachary and presses the enter key on the keyboard, the follow- nges the name of the customer in the first sre ment will be issued and executed. ecord shown in the form in UPDATE customer SET cus t name = 'Zachary' WHERE custid = '1000'; he used for other types of interaction that an end user has with the data in the The example in Figure 6.24 shows a form that is used for a search and retrieval. ta is entered in the Customer Name box and the search button is clicked, is issued on the user's behalf. Let us assume the user entered the value forms can CUSTOMERS To Delete Records: Highlight the records and press delete on your keyboard To Change a Record: Change any value in any of the rows and press enter on your keyboard Customer ID Customer Name 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 Zip 60111 60333 60222 60555 60444 60555 60333 60555 60222 60333 60111 60666 60444 Matt Pam Sally Bob Adam Steve Pam Emma Peter Fiona RE 6.23 An example of a form for data update for the relation CUSTOMER
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
