Database Editor results error for me

[WebDeb]

Hello, I'm back... with another wee problem to solve...

I have completed a Database Results Wizard in FP2003 and I can View
all the records, I can log in the database Editor with the login and
password I set for it during the wizard building, I can fill out a
Submission form just dandy to ADD a record I can even DELETE a record
but do ya think I can edit one?

In the Database Editor results page I can select a record and it fills
up the bottom of the screen. I scroll down to the end of the record
click EDIT and the filled in record form comes up. Sweet so far.

I make a change in the form and click OK and for all my trouble the
form is replaced with a page saying

Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

That's not a lot of information for me and I just bet someone here can
suggest what to look for to find the error since I haven't been able
to find anything on the MS site.

Thank you in advance again for your pulling me out of my pile.
You are such great folks to share your expertise.

Deb

 

[dave]

In the hidden folder /_fpclass, open the file FPDBRGN1.INC,
set
fp_DEBUG = False
to
fp_DEBUG = True

This will give you a true error

 

[D McClellan]

Excellent!
Now it says

Database Results Wizard Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

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

I saw this message before somewhere but I am not sure exactly how and what
values to put in what form fields.

Can you keep pulling me up? Thanks so very much!

Deb

 

[Joe B]

Hmm, I am getting the same thing, has anyone got any input to this
error??

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

--

Excellent!
Now it says

Database Results Wizard Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

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

I saw this message before somewhere but I am not sure exactly how and what
values to put in what form fields.

Can you keep pulling me up? Thanks so very much!

Deb

In the hidden folder /_fpclass, open the file FPDBRGN1.INC,
set
fp_DEBUG = False
to
fp_DEBUG = True

This will give you a true error

 

[Joe B]

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...


--

Hmm, I am getting the same thing, has anyone got any input to this
error??

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

--

Excellent!
Now it says

Database Results Wizard Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

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

I saw this message before somewhere but I am not sure exactly how and what
values to put in what form fields.

Can you keep pulling me up? Thanks so very much!

Deb

In the hidden folder /_fpclass, open the file FPDBRGN1.INC,
set
fp_DEBUG = False
to
fp_DEBUG = True

This will give you a true error


Hello, I'm back... with another wee problem to solve...

I have completed a Database Results Wizard in FP2003 and I can View
all the records, I can log in the database Editor with the login and
password I set for it during the wizard building, I can fill out a
Submission form just dandy to ADD a record I can even DELETE a record
but do ya think I can edit one?

In the Database Editor results page I can select a record and it fills
up the bottom of the screen. I scroll down to the end of the record
click EDIT and the filled in record form comes up. Sweet so far.

I make a change in the form and click OK and for all my trouble the
form is replaced with a page saying

Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

That's not a lot of information for me and I just bet someone here can
suggest what to look for to find the error since I haven't been able
to find anything on the MS site.

Thank you in advance again for your pulling me out of my pile.
You are such great folks to share your expertise.

Deb