Before starting, you must complete the following tasks:
You must build one or more pages that let the user find the record they want
to delete. For more information, see Identifying the record to delete.
You must add logic to the delete page allowing it to retrieve the user’s
chosen record from the database in preparation for deletion. For instructions,
see Retrieving the record to delete.
Optionally, you can display the record on the page so the user can view it before
deleting it. For instructions, see Displaying the data to be deleted.
You must add an HTML form with a Submit button to the delete page to send the
delete command to the server. For instructions, see Sending the delete command
to the server.
With these prerequisites in place, you can complete the Delete Record dialog
box.
Procedure
In the Connection pop-up menu, select a connection to the database containing
the stored procedure.
Click the Define button if you need to define a connection.
In the Delete from Table pop-up menu, select the database table that contains
the record to delete.
In the Select Record From pop-up menu, specify the recordset that contains the
record to delete.
In the Unique Key Column pop-up menu, select a key column (usually the record
ID column) to identify the record in the database table.
If the value is a number, select the Numeric option. A key column usually accepts
only numeric values, but sometimes it accepts text values.
In the Delete By Submitting pop-up menu, specify the HTML form with the Submit
button that sends the delete command to the server.
In the After Deleting, Go To box, enter the page to open after the record is
deleted from the database table or click the Browse button to browse to the
file.
automatically chooses the first form on your page.
Click OK.
adds a server behavior to the page that lets users delete records
in a database table by clicking the Submit button on the form.
1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 422