The information in this article applies to:
- Microsoft dbWeb versions 1.0, 1.1
SUMMARY
Microsoft DbWeb can insert, update, or delete records from various back-end
databases. Typically, you want to supply the user with some information
about whether their insert, update, or delete was successful. DbWeb
supplies a default insert, update, and delete success/failure message.
This is generally enough information; however, you may want to customize
this message.
Your custom insert, update, and delete message can be an entire HTML
document that can take on the look and feel of the rest of your HTML
documents. You can customize these messages in two ways.
First, you can type the HTML directly in the property sheet of the "Insert
success msg," "Insert fail msg," "Update success msg," "Update fail msg,"
"Delete success msg," and "Delete fail msg."
Second, you can supply a URL to an HTML document; however, you must use the
<META HTTP-EQUIV="REFRESH" CONTENT="0; URL=/dbWeb/MyHTML.htm"> HTML tag.
However, this HTML tag is not supported by all browsers. Some browsers that
do support it are Microsoft Internet Explorer versions 3.0 and 2.0, and
Netscape versions 3.0 and 2.0.
MORE INFORMATION
The following steps detail the two methods described above.
Method 1 - Typing HTML Tags into Property Sheet
- Start dbWeb Administrator.
- Select and open the Customers sample schema.
- In the Schema tab, click to select the Insert check box.
- Click the Ins/Upd/Del tab.
- Under "Data columns in selected table," expand the Customers table by
double-clicking it.
- Click the Add-All button.
- Under "Insert data columns," select "Customers.Customer ID."
- Click the Properties button.
- On the properties sheet, make sure that you are looking at the
Insert/Update Form properties. To do this, just below the titlebar of
the properties sheet, there is a drop-down list. Click the arrow to
view your three selections, and choose the Insert/Update Form
Properties.
- Type the following in the "Insert success msg" property:
<HTML><TITLE>Insert Success</TITLE><BODY>Your insert was
successful</BODY></HTML>
- Type the following into the "Insert fail msg" property:
<HTML><TITLE>Insert Failed</TITLE><BODY>Your insert
failed</BODY></HTML>
NOTE: The "Insert success msg," "Insert fail msg," "Update success
msg," "Update fail msg," "Delete success msg," and "Delete fail msg"
properties are limited to 2047 characters. Also, you can use plain text
without the HTML tags. The HTML tags will allow you to customize the
look in your Internet browser.
- Close the properties sheet.
- Click the Apply button.
Method 2 - Using a URL to Reference a Custom HTML Document
NOTE: The following example references two HTML documents called
MySuccess.htm (insert success message) and MyFail.htm (insert failure
message). Just substitute your own custom HTML document names for
MySuccess.htm and MyFail.htm.
- Start dbWeb Administrator.
- Select and open the Customers sample schema.
- On the Schema tab, click to select the Insert check box.
- Click the Ins/Upd/Del tab.
- Under "Data columns in selected table," expand the Customers table by
double-clicking it.
- Click the Add-All button.
- Under "Insert data columns," select "Customers.Customer ID."
- Click the Properties button.
- On the properties sheet make sure that you a looking at the
Insert/Update Form Properties. To do this, just below the titlebar of
the properties sheet, there is a drop-down list. Click the arrow to
view your three selections, and choose the Insert/Update Form
Properties.
- Type the following into the "Insert success msg" property:
<META HTTP-EQUIV="REFRESH" CONTENT="0; URL=/dbWeb/MySuccess.htm">
- Type the following into the "Insert fail msg" property:
<META HTTP-EQUIV="REFRESH" CONTENT="0; URL=/dbWeb/MyFail.htm">
NOTE: The above "URL=/dbWeb/MySuccess.htm" assumes that your relative
path to the dbWeb documents folder is "/dbweb/" and your HTML document
is located in that folder.
- Close the Properties sheet.
- Click the Apply button.
To test these two methods, open your favorite browser and use the "getqbe"
method to open the Customers sample schema. Click the Submit Query button.
On the next page, click the Submit button. Type a new CompanyID and Company
Name, and then click Submit Insert. You should see your custom success
message. To see your custom failure message follow the same steps, except
do not type any information on the submit customer page, and then click
Submit Insert. You should now see your custom failure message.
REFERENCES
For more information about Insert/Update/Delete properties, search for
"insert/update/delete properties sheet," using the dbWeb 1.0/1.1 Help
"Search for Help On...."
|