DataBase Edit issue FP2003

R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top