DRW Error

[Steve]

On Page 1, the user clicks a link containing an ID number pulled from an
Access db and is sent to Page 2. On Page 2 I am using the following code to
create a custom query using the FrontPage Database Results Wizard...

UPDATE Results SET new_message = '0' WHERE ID = '::ID::'

The user receives the following error message on Page 2...

Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

What do I need to do to eliminate the error and have the record's column
value (new_message) updated to 0 in the table called Results?

Thanks for the help!

 

[Kathleen Anderson [MVP - FP]]

To see the true error, open the hidden folder /_fpclass/ and edit the
fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True