DataBase Errors Help I'm going Crazy

[Joe B]

FP2003
I used the database wizard to build a complete set of forms, database etc.
I can add records, list records, build lists for pages, and even delete
records (although I get the 'top.list.location' error below, it still
deletes them).
What I cannot do is update records. The edit.asp populates fine,
and the form for re-submitting the data is populated fine.
But when I push the update button which send the data to update.asp
it fails.

What I get as an error is

Line 18
error: 'top.list.location' is null or not an object

Setting the fpdbrgn1.inc debug line to true results in this error along with
the 'top.list.location' error above.

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.

This sounds a lot like the knowledge base article regarding ::timestamp::
I cannot find any reference to ::timestamp:: on my site that the KB
article talks about
All of the (known) fields do have default values.
Anybody have a clue??

Thanks

 

[Tom Miller]

FP2003
I used the database wizard to build a complete set of forms, database etc.
I can add records, list records, build lists for pages, and even delete
records (although I get the 'top.list.location' error below, it still
deletes them).
What I cannot do is update records. The edit.asp populates fine,
and the form for re-submitting the data is populated fine.
But when I push the update button which send the data to update.asp
it fails.

What I get as an error is

Line 18
error: 'top.list.location' is null or not an object

Setting the fpdbrgn1.inc debug line to true results in this error along with
the 'top.list.location' error above.

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.

This sounds a lot like the knowledge base article regarding ::timestamp::
I cannot find any reference to ::timestamp:: on my site that the KB
article talks about
All of the (known) fields do have default values.
Anybody have a clue??

Thanks

I don't know if this qualifies as a clue. And you do have to know a little
about ASP and/or SQL to make it work, but have you tried to "read" the
source code (eg. the .ASP page that creates the update page your submitting?
As well as the actual page). Since it is complaining about a "syntax
error" I would want to view the code to see if I could see an SQL syntax
error....

 

[Janet]

Got it.... just don't name any fields year month or day
Evidently these field names get passed on and whack the
underlying code (VB?) where they are protected names.
The field names are not protected as text all the way thru.
This is a guess. But these field name sure cause havoc.
Changing to years months days fixed it all...