India seo web development website designer freelance
Retrieving the record to update
After the results page passes a URL parameter to the update page identifying
the record to update, the update page must read the parameter, retrieve the
record from the database table, and store it temporarily in a recordset.
To retrieve the record to update:
- 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 update is located
using the Connection and Table pop-up menus.
- Click the Selected option and select a key column (usually the record ID
column) and the columns containing the data to be updated.
- 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 update page will generate a recordset containing only the selected record
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