Identifying the record to delete When users want to delete a record, they must first find that record in the database. Accordingly, you need a search and a results page to work with the delete page. For instructions on creating a search and a results page, see Building Pages that Search Databases.
The results page tells the delete page which record to delete by passing it a URL parameter. Therefore, make sure the results page has a Go to Detail Page server behavior that names the delete page as the detail page. For instructions, see Modifying a results page to work with a detail page.
Retrieving the record to delete
After the results page passes a URL parameter to the delete page identifying
the record to delete, the delete page must read the parameter, retrieve the
record from the database table, and temporarily store the record in a recordset.
To retrieve the record to delete:
In the Bindings panel (Window > Bindings), click the plus (+) button and
choose Recordset or DataSet (ASP.NET).
If the advanced dialog box appears, click the Simple button to open the simple
dialog box.
Name the recordset and specify where the data you want to delete is located
using the Connection and Table pop-up menus.
In the Columns area, select the All option to select all the columns in the
database table.
Configure the Filter area so that the value of your key column equals the value
of the corresponding URL parameter passed by the results page.
This kind of filter creates a recordset that contains only the record specified
by the results page. For example, if your key column contains record ID information
and is called PRID, and if the results page passes the corresponding record
ID information in the URL parameter called id, then here’s how your Filter
area should look:
Click OK.
When the user selects a record on the results page, the delete page generates
a recordset containing only the selected record.
Next you’ll add a read-only display of the data to be deleted.
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