FP2003 DB edit issue

[RichieRich]

I created a FP database site using the built in wizard and all work great except for the editing part. when I go into the database
editor and attempt to modify an existing record, I get this error after submitting the edit:

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

One or more form fields were empty. You should provide default values for all form fields that are used in the query.

I have looked at KB828898 and some others, but KB828898 seems to be the right article, but cannot find the timestamp entry anywhere
in my update.asp script. Can anyone help in this frustrating part of an otherwise great FP experience?

thanks

 

[rballard]

I had the same problem and figured out that the true reason for the error was because of a Date Field. My database is in Access however so this may not be the same cause of your problem. The date field in the script has to read #::date::# instead of 'date'.

Hope this helps.