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

 

[Guest]

Problem Description: RE: ERROR MESSAGE "The operation failed. If this continues, please contact your server administrator.

NOW CHECK THIS

I TOOK A COPY OF THE FILE "fpdbrgn1.inc" FROM THE FOLDER "_fpclass" FROM A WEB THAT I HAD STORED ON MY HARD DISK LAST YEAR AND COPIED IT TO THE SAME FOLDER ON THE WEB SERVER OF ONE OF MY WEBS THAT HAS BEEN EXPERIENCING THE ERROR - AND GUESS WHAT??? ALL QUERIES WORK AGAIN!!!

WHAT DO YOU ALL MAKE OF THAT????

 

[Kevin Spencer]

BTW, your caps lock key is on.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

I'M NOT USING ANY OF THOSE FIELD NAMES AND STILL GET THE ERROR.

----- Joe B wrote: -----

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 how and
what

and it
fills someone here
can

 

[Mettá]

This is of interest to me as I have the same error all over a number of
sites. It seems since updating to SP3 from MS although I am not 100% sure
this is the cause! Also DISTINCT queries no longer work via the DRW custom
sql

M

Problem Description: RE: ERROR MESSAGE "The operation failed. If this

continues, please contact your server administrator."

NOW CHECK THIS!

I TOOK A COPY OF THE FILE "fpdbrgn1.inc" FROM THE FOLDER "_fpclass" FROM A

WEB THAT I HAD STORED ON MY HARD DISK LAST YEAR AND COPIED IT TO THE SAME
FOLDER ON THE WEB SERVER OF ONE OF MY WEBS THAT HAS BEEN EXPERIENCING THE
ERROR - AND GUESS WHAT??? ALL QUERIES WORK AGAIN!!!!

 

[Mettá]

This is of interest to me as I have the same error all over a number of
sites. It seems since updating to SP3 from MS although I am not 100% sure
this is the cause! Also DISTINCT queries no longer work via the DRW custom
sql

M

Problem Description: RE: ERROR MESSAGE "The operation failed. If this

continues, please contact your server administrator."

NOW CHECK THIS!

I TOOK A COPY OF THE FILE "fpdbrgn1.inc" FROM THE FOLDER "_fpclass" FROM A

WEB THAT I HAD STORED ON MY HARD DISK LAST YEAR AND COPIED IT TO THE SAME
FOLDER ON THE WEB SERVER OF ONE OF MY WEBS THAT HAS BEEN EXPERIENCING THE
ERROR - AND GUESS WHAT??? ALL QUERIES WORK AGAIN!!!!

 

[Mettá]

This is of interest to me as I have the same error all over a number of
sites. It seems since updating to SP3 from MS although I am not 100% sure
this is the cause! Also DISTINCT queries no longer work via the DRW custom
sql

M

I BET YOU ANYTHING THAT NO ONE HERE CAN ANSWER YOU!! HAHAHA GOOD LUCK!!

Problem Description: RE: ERROR MESSAGE "The operation failed. If this

continues, please contact your server administrator."

IF YOU SEARCH MSN SEARCH ON THE ABOVE ERROR STRING, YOU WILL FIND 5599

SITES THAT ARE EXPERIENCING THE SAME PROBLEM AS I AM FOLLOWING INSTALLATION
OF SP3 FOR OFFICE XP.