DBWEB: Updates Not Working Using Default dbWeb Documents
ID: Q155291
|
The information in this article applies to:
-
Microsoft dbWeb, version 1.1
SYMPTOMS
When using the dbWeb default HTML update document, if you click the Submit
Update button, a blank screen appears on your browser and no success or
failure message is displayed for the update. When you look in the
underlying table for the update, you notice that the data has not been
changed.
CAUSE
The new caching functionality built into dbWeb version 1.1 caused the
updates not to work properly.
RESOLUTION
There are two ways to work around this problem:
- Create a custom DBX to perform the update.
- Download dbWeb version 1.1a from the Microsoft dbWeb internet site at
the following Web address:
http://www.microsoft.com/intdev/dbweb
STATUS
Microsoft has confirmed this to be a problem in Microsoft dbWeb
version 1.1. This problem does not occur in dbWeb versions 1.0 or 1.1a.
MORE INFORMATIONSteps to Reproduce Problem
- Start the dbWeb Administrator.
- Highlight the Employees schema, and then click Modify Schema.
- Click the Schema tab, and then click to select the Update check box
under "Allow actions on data."
- Click the Tabular tab, highlight the Employees.Employee ID field, and
then click the Properties button.
- In the properties sheet, select Column Properties.
- Click the Automatic Link URL property, and then click the Build button
(the button with three dots).
- Click the Link Type tab, and in the "Automatic Link from
(Employees.Employee ID)" dialog box, select Drill Down.
- Click the Information tab, and then click the New Criteria button.
- In the "Automatic Link Drill Down" dialog box, click Employee ID, and
then click OK.
- In the "Automatic Link from (Employees.Employee ID)" dialog box, click
OK.
- Close the properties sheet, and then click Apply.
- Click the Ins/Upd/Del tab, and click the Employees table in the "Data
columns in selected tables."
- Click the Add All button.
NOTE: You will receive an error that states "Photo is a binary object.
Binary large object fields are not supported." Updates, Inserts, or
Deletes don't support binary large objects. Click the OK button to
continue.
- In the "Update data columns" section, click the Employees.Employee ID
field, and then click Properties.
- In the properties sheet, select Column Properties.
- Click the Key property, and then click "Key (counter)."
- Close the properties sheet, and then click Apply.
- Open your internet browser and type the URL to the Employees schema.
Drill down to just one record. Make sure you click to select the Update
option, and then click the Submit button. Change the record, and then
click Submit Update. Note that your browser returns a blank page with
no errors. If you view the source for the page (if your browser is
capable), you'll see that the only tag on the page is </HTML>.
REFERENCES
For more information about Creating Custom Update DBXs, please see the
following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q154867
TITLE : DBWEB: How to Create a Custom Update DBX
For more information about DBXs, search for "DBX," and then "Specifying
Custom Format Files" using the Microsoft dbWeb 1.1 Help Search for Help on.
For more information about DBX tags, search for "DBX tag formats," and then
"DBX tag formats" using the Microsoft dbWeb 1.1 Help Search for Help on.
For more information about DBX editor, search for "DBX editor," and then
"DBX Editor" using the Microsoft dbWeb 1.1 Help Search for Help on.
Additional query words:
Keywords : DbwebUsage
Version : WINDOWS:1.1
Platform : WINDOWS
Issue type : kbbug
|