error message in FP Database editor

M

Miklb58

ok, I made a database, entered some data into the fields using the database
editor, then I tried to edit one of the records, and got this message
Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

I since have shut everything down, and re-booted, re-connected to the
server, but it still does it, what am I doing wrong?
 
K

Kathleen Anderson [MVP - FrontPage]

The FP2003 code has changed slightly. 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
 
M

Miklb58

Thanks, for the post, I did as you suggested, and now when I update a record
it says
""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.""

Could this just be because I have empty form fileds? If so is there any harm
leving them empty?
This db is being used to supply data TO a web page, without input from site
visitors.

Mike
 
M

Miklb58

Just for the fun of it I just went into the database editor and filled data
into the one empty field, and this time the message in the lower frame says
""Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine"
and the edit didn't take.

Mike
 
M

Miklb58

I am puzzled........I have deleted and started over 3 or 4 times, re-making
the database with DBIW, and each time I get that same error message as in my
prev. post. I made one database without adding any new fields, and upon
completion, that one works fine with no errors, but when I make one the way I
wan't it, it goofs up. I am adding about 20 fields, and upon completion I
have to edit that file you told me to, then I get the second eroor and the DB
does not update if I "edit" a record. I can make a new record ok, I just
can't edit one

Mike
 
T

Thomas A. Rowe

Please explain "but when I make one the way I wan't it, it goofs up"

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
M

Miklb58

Thanks Thomas for responding, what I mean is i make a DB using DBIW in
FP2003. It has the "key" field, then a "number field, and the rest are text
fields as many as 25 in all. I set the "number" field as a text box, and set
a default value for all fields. After building the db, entering values into
each field, and hit enter, the db results fine, but I go back into the
editor, click "edit" a record, make a change, then hit enter and I get the
error
""Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine"

Last night I went to Kathleen Andersons site, and followed a link that she
has there for the first error message that I was getting, so I did a search @
MS for the second error message and it brought up a result, but I haven't had
a chance today to go back there & research it, but I will later.

Mike
 
S

Stefan B Rusynko

See http://www.aspfaq.com/show.asp?id=2400




| Thanks Thomas for responding, what I mean is i make a DB using DBIW in
| FP2003. It has the "key" field, then a "number field, and the rest are text
| fields as many as 25 in all. I set the "number" field as a text box, and set
| a default value for all fields. After building the db, entering values into
| each field, and hit enter, the db results fine, but I go back into the
| editor, click "edit" a record, make a change, then hit enter and I get the
| error
| ""Database Results Wizard Error
| Description: Syntax error in UPDATE statement.
| Number: -2147217900 (0x80040E14)
| Source: Microsoft JET Database Engine"
|
| Last night I went to Kathleen Andersons site, and followed a link that she
| has there for the first error message that I was getting, so I did a search @
| MS for the second error message and it brought up a result, but I haven't had
| a chance today to go back there & research it, but I will later.
|
| Mike
|
|
|
| "Thomas A. Rowe" wrote:
|
| > Please explain "but when I make one the way I wan't it, it goofs up"
| >
| > --
| > ==============================================
| > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > ==============================================
| > If you feel your current issue is a results of installing
| > a Service Pack or security update, please contact
| > Microsoft Product Support Services:
| > http://support.microsoft.com
| > If the problem can be shown to have been caused by a
| > security update, then there is usually no charge for the call.
| > ==============================================
| >
| > | > >I am puzzled........I have deleted and started over 3 or 4 times, re-making
| > > the database with DBIW, and each time I get that same error message as in my
| > > prev. post. I made one database without adding any new fields, and upon
| > > completion, that one works fine with no errors, but when I make one the way I
| > > wan't it, it goofs up. I am adding about 20 fields, and upon completion I
| > > have to edit that file you told me to, then I get the second eroor and the DB
| > > does not update if I "edit" a record. I can make a new record ok, I just
| > > can't edit one
| > >
| > > Mike
| > >
| > > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >
| > >> The FP2003 code has changed slightly. 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
| > >>
| > >>
| > >> --
| > >> ~ Kathleen Anderson
| > >> Microsoft MVP - FrontPage
| > >> Spider Web Woman Designs
| > >> web: http://www.spiderwebwoman.com/resources/
| > >>
| > >>
| > >> | > >> > ok, I made a database, entered some data into the fields using the
| > >> > database
| > >> > editor, then I tried to edit one of the records, and got this message
| > >> > Database Results Wizard Error
| > >> > The operation failed. If this continues, please contact your server
| > >> > administrator.
| > >> >
| > >> > I since have shut everything down, and re-booted, re-connected to the
| > >> > server, but it still does it, what am I doing wrong?
| > >>
| > >>
| > >>
| >
| >
| >
 

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