Database Wizard Error on updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Running FP2003 with both service packs. Using Access 2002. One website (used
for testing and created before I installed the service packs) I can use the
Database Wizard, publish up and everything works fine. Works just the same
after I installed the service packs. Another site, created before and after
the service packs (trying to figure out what the hell is wrong), will not
allow an update, but gives the following error:
Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

The first site that works good, I even published it to the other site just
to make sure it is not the hosting. The first site works just fine no matter
where I put it. All of this crap worked in FP2002, but we just changed
hosting people and want to be able to use FP2003. Any ideas on what is going
on ?

Thanks,
Sam
 
Ran a test. Created a new website with the Database Wizard only and published
it up. Everything ran fine, so I guess I will start this project, once
again, from the center out (create the db first then the web pages).

Sam
 
FYI
To see the true error when working w// the DBRW , open the hidden folder /_fpclass/ and edit the
fpdbrgn1.inc file. At about line 19, change :
fp_DEBUG = False
to :
fp_DEBUG = True


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ran a test. Created a new website with the Database Wizard only and published
| it up. Everything ran fine, so I guess I will start this project, once
| again, from the center out (create the db first then the web pages).
|
| Sam
| --
| samG
|
|
| "samG" wrote:
|
| > Running FP2003 with both service packs. Using Access 2002. One website (used
| > for testing and created before I installed the service packs) I can use the
| > Database Wizard, publish up and everything works fine. Works just the same
| > after I installed the service packs. Another site, created before and after
| > the service packs (trying to figure out what the hell is wrong), will not
| > allow an update, but gives the following error:
| > Database Results Wizard Error
| > The operation failed. If this continues, please contact your server
| > administrator.
| >
| > The first site that works good, I even published it to the other site just
| > to make sure it is not the hosting. The first site works just fine no matter
| > where I put it. All of this crap worked in FP2002, but we just changed
| > hosting people and want to be able to use FP2003. Any ideas on what is going
| > on ?
| >
| > Thanks,
| > Sam
| > --
| > samG
 
Did what you said and here is the error
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.

Check MS and found KB828898, however, cannot find "Timestamp" anywhere
except in fpdbform.inc. The article refers to update.asp. So, any ideas ?

Thanks,
 
Hi Sam,

samG said:
Did what you said and here is the error
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.
Click to expand...

This happens when a form field is empty, and the database table requires a
value in the column. It can happen when the column is a numeric or date
column, or when the column is of a text data type but doesn't allow empty
strings.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.
 
Kevin

I checked the db field properties and everything is as it should be. What I
did, however, was to create another record with every field filled out.
Still the same error results.

(Getting frustrated here in South Carolina)
 
Check the spelling of the form field names in your query. The error
indicates that one of the form fields is blank. If you filled them all out
and got the error, it is entirely possible you misspelled the field name in
the query. Can you post the query?

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.
 
Kevin, here is the query from update.asp

fp_sQry="UPDATE Results SET Broker = '::Broker::' , Bnum = '::Bnum::' , TM =
'::TM::' , Comp = '::Comp::' , Type = '::Type::' , Price = ::Price:: ,
Address = '::Address::' , Location = '::Location::' , County = '::County::' ,
Rms = ::Rms:: , Bdrms = ::Bdrms:: , Baths = '::Baths::' , SqFt = ::SqFt:: ,
Heating = '::Heating::' , Cooling = '::Cooling::' , Appliances =
'::Appliances::' , Floors = '::Floors::' , Fireplace = '::Fireplace::' ,
Parking = '::Parking::' , Water = '::Water::' , Sewer = '::Sewer::' ,
Exterior = '::Exterior::' , Substructure = '::Substructure::' , YrBlt =
'::YrBlt::' , RoofAge = '::RoofAge::' , LotSize = '::LotSize::' , Notes =
'::Notes::' , TownTxs = '::TownTxs::' , CtyTxs = '::CtyTxs::' , AvgUtilBill =
'::AvgUtilBill::' , Occupied = '::Occupied::' , Instructions =
'::Instructions::' , DateListed = '::DateListed::' , DateSold =
'::DateSold::' , FinalPrice = ::FinalPrice:: , Concessions =
'::Concessions::' , ListStatus = '::ListStatus::' WHERE (Key = ::Key::)"

Sorry, it is a long one.
 
It looks like you may have a column or 2 named with a Keyword. "Type" for
example, Try putting all database object names inside [square brackets],
which will inform the parser that these are database objects rather than
keywords. And did you check your speeling?

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.
 
Kevin

I have setup the database so many times for testing it may be true I have a
word spelled wrong, but that is OK as long as I get it to display correctly.
Now, after your comments about a Keyword, I checked my sheets (didn't do this
before) on reserved words for Jet 4.0 and sure enough "Comp" is one. That is
enough to throw it out wack and cause the error. I also noticed some others
that I wanted to use in another database and now know I will have to change
that. I will redo the database and put a "z" or an "x" before each field
names and see what happens.

Thanks,

Sam
--
samG


Kevin Spencer said:
It looks like you may have a column or 2 named with a Keyword. "Type" for
example, Try putting all database object names inside [square brackets],
which will inform the parser that these are database objects rather than
keywords. And did you check your speeling?

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.
Click to expand...
 
All you have to do is put the names in square brackets in your query.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.

samG said:
Kevin

I have setup the database so many times for testing it may be true I have
a
word spelled wrong, but that is OK as long as I get it to display
correctly.
Now, after your comments about a Keyword, I checked my sheets (didn't do
this
before) on reserved words for Jet 4.0 and sure enough "Comp" is one. That
is
enough to throw it out wack and cause the error. I also noticed some
others
that I wanted to use in another database and now know I will have to
change
that. I will redo the database and put a "z" or an "x" before each field
names and see what happens.

Thanks,

Sam
--
samG


Kevin Spencer said:
It looks like you may have a column or 2 named with a Keyword. "Type" for
example, Try putting all database object names inside [square brackets],
which will inform the parser that these are database objects rather than
keywords. And did you check your speeling?

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.

samG said:
Kevin, here is the query from update.asp

fp_sQry="UPDATE Results SET Broker = '::Broker::' , Bnum = '::Bnum::' ,
TM
=
'::TM::' , Comp = '::Comp::' , Type = '::Type::' , Price = ::Price:: ,
Address = '::Address::' , Location = '::Location::' , County =
'::County::' ,
Rms = ::Rms:: , Bdrms = ::Bdrms:: , Baths = '::Baths::' , SqFt =
::SqFt::
,
Heating = '::Heating::' , Cooling = '::Cooling::' , Appliances =
'::Appliances::' , Floors = '::Floors::' , Fireplace = '::Fireplace::'
,
Parking = '::Parking::' , Water = '::Water::' , Sewer = '::Sewer::' ,
Exterior = '::Exterior::' , Substructure = '::Substructure::' , YrBlt =
'::YrBlt::' , RoofAge = '::RoofAge::' , LotSize = '::LotSize::' , Notes
=
'::Notes::' , TownTxs = '::TownTxs::' , CtyTxs = '::CtyTxs::' ,
AvgUtilBill =
'::AvgUtilBill::' , Occupied = '::Occupied::' , Instructions =
'::Instructions::' , DateListed = '::DateListed::' , DateSold =
'::DateSold::' , FinalPrice = ::FinalPrice:: , Concessions =
'::Concessions::' , ListStatus = '::ListStatus::' WHERE (Key =
::Key::)"

Sorry, it is a long one.
--
samG


:

Check the spelling of the form field names in your query. The error
indicates that one of the form fields is blank. If you filled them all
out
and got the error, it is entirely possible you misspelled the field
name
in
the query. Can you post the query?

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.

Kevin

I checked the db field properties and everything is as it should be.
What
I
did, however, was to create another record with every field filled
out.
Still the same error results.

(Getting frustrated here in South Carolina)
--
samG


:

Hi Sam,

Did what you said and here is the error
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 happens when a form field is empty, and the database table
requires
a
value in the column. It can happen when the column is a numeric or
date
column, or when the column is of a text data type but doesn't allow
empty
strings.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.
Click to expand...
Click to expand...
Click to expand...
 
Thanks for all your help Kevin. It wasn't until you said "Keywords" that it
triggered Reserved Words for Jet 4.0 in my mind. I totally forgot about that
and SQL-92 reserved words. Everything is working OK now. Thanks again.

Sam
--
samG


Kevin Spencer said:
All you have to do is put the names in square brackets in your query.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.

samG said:
Kevin

I have setup the database so many times for testing it may be true I have
a
word spelled wrong, but that is OK as long as I get it to display
correctly.
Now, after your comments about a Keyword, I checked my sheets (didn't do
this
before) on reserved words for Jet 4.0 and sure enough "Comp" is one. That
is
enough to throw it out wack and cause the error. I also noticed some
others
that I wanted to use in another database and now know I will have to
change
that. I will redo the database and put a "z" or an "x" before each field
names and see what happens.

Thanks,

Sam
--
samG


Kevin Spencer said:
It looks like you may have a column or 2 named with a Keyword. "Type" for
example, Try putting all database object names inside [square brackets],
which will inform the parser that these are database objects rather than
keywords. And did you check your speeling?

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.

Kevin, here is the query from update.asp

fp_sQry="UPDATE Results SET Broker = '::Broker::' , Bnum = '::Bnum::' ,
TM
=
'::TM::' , Comp = '::Comp::' , Type = '::Type::' , Price = ::Price:: ,
Address = '::Address::' , Location = '::Location::' , County =
'::County::' ,
Rms = ::Rms:: , Bdrms = ::Bdrms:: , Baths = '::Baths::' , SqFt =
::SqFt::
,
Heating = '::Heating::' , Cooling = '::Cooling::' , Appliances =
'::Appliances::' , Floors = '::Floors::' , Fireplace = '::Fireplace::'
,
Parking = '::Parking::' , Water = '::Water::' , Sewer = '::Sewer::' ,
Exterior = '::Exterior::' , Substructure = '::Substructure::' , YrBlt =
'::YrBlt::' , RoofAge = '::RoofAge::' , LotSize = '::LotSize::' , Notes
=
'::Notes::' , TownTxs = '::TownTxs::' , CtyTxs = '::CtyTxs::' ,
AvgUtilBill =
'::AvgUtilBill::' , Occupied = '::Occupied::' , Instructions =
'::Instructions::' , DateListed = '::DateListed::' , DateSold =
'::DateSold::' , FinalPrice = ::FinalPrice:: , Concessions =
'::Concessions::' , ListStatus = '::ListStatus::' WHERE (Key =
::Key::)"

Sorry, it is a long one.
--
samG


:

Check the spelling of the form field names in your query. The error
indicates that one of the form fields is blank. If you filled them all
out
and got the error, it is entirely possible you misspelled the field
name
in
the query. Can you post the query?

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.

Kevin

I checked the db field properties and everything is as it should be.
What
I
did, however, was to create another record with every field filled
out.
Still the same error results.

(Getting frustrated here in South Carolina)
--
samG


:

Hi Sam,

Did what you said and here is the error
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 happens when a form field is empty, and the database table
requires
a
value in the column. It can happen when the column is a numeric or
date
column, or when the column is of a text data type but doesn't allow
empty
strings.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top