DIW - Cant Update records

[Mick]

Hi, its nearly working! DIW created all the necessary pages, all uploaded to
the server ok. I can add and delete records ok to the database on the server
using the DI. However when attempt to "update" an existing record, I get the
following error. Can anyone please suggest a solution?

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
regards
Mick

 

[Stefan B Rusynko]

80040E14 usually is a field error (null fields)
See http://www.aspfaq.com/show.asp?id=2400

PS
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
And in IE Tools Internet Options Advanced turn off show friendly errors





| Hi, its nearly working! DIW created all the necessary pages, all uploaded to
| the server ok. I can add and delete records ok to the database on the server
| using the DI. However when attempt to "update" an existing record, I get the
| following error. Can anyone please suggest a solution?
|
| Database Results Wizard Error
| Description: Syntax error in UPDATE statement.
| Number: -2147217900 (0x80040E14)
| Source: Microsoft JET Database Engine
| regards
| Mick

 

[Mick]

Stefan, I entered default values to all fields, all ok now, cheers
Mick