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

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

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/FrontPa...3/Default.aspx
_____________________________________________


"samG" <(E-Mail Removed)> wrote in message news:A9B4CCDC-4456-4E10-AAFE-(E-Mail Removed)...
| 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,
--
samG


"Stefan B Rusynko" wrote:

> 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/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "samG" <(E-Mail Removed)> wrote in message news:A9B4CCDC-4456-4E10-AAFE-(E-Mail Removed)...
> | 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
>
>
>

Hi Sam,

"samG" <(E-Mail Removed)> wrote in message
news:32D1B98E-31BB-478C-B6D0-(E-Mail Removed)...
> 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.

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


"Kevin Spencer" wrote:

> Hi Sam,
>
> "samG" <(E-Mail Removed)> wrote in message
> news:32D1B98E-31BB-478C-B6D0-(E-Mail Removed)...
> > 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.
>
>
>

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.

"samG" <(E-Mail Removed)> wrote in message
news:A2716E22-55CD-4752-B8B2-(E-Mail Removed)...
> 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
>
>
> "Kevin Spencer" wrote:
>
>> Hi Sam,
>>
>> "samG" <(E-Mail Removed)> wrote in message
>> news:32D1B98E-31BB-478C-B6D0-(E-Mail Removed)...
>> > 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.
>>
>>
>>

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 = ':ateListed::' , DateSold =
':ateSold::' , FinalPrice = ::FinalPrice:: , Concessions =
'::Concessions::' , ListStatus = '::ListStatus::' WHERE (Key = ::Key:"

Sorry, it is a long one.
--
samG


"Kevin Spencer" wrote:

> 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.
>
> "samG" <(E-Mail Removed)> wrote in message
> news:A2716E22-55CD-4752-B8B2-(E-Mail Removed)...
> > 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
> >
> >
> > "Kevin Spencer" wrote:
> >
> >> Hi Sam,
> >>
> >> "samG" <(E-Mail Removed)> wrote in message
> >> news:32D1B98E-31BB-478C-B6D0-(E-Mail Removed)...
> >> > 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.
> >>
> >>
> >>
>
>
>

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" <(E-Mail Removed)> wrote in message
news:FF5980AB-985F-434A-B0FF-(E-Mail Removed)...
> 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 = ':ateListed::' , DateSold =
> ':ateSold::' , FinalPrice = ::FinalPrice:: , Concessions =
> '::Concessions::' , ListStatus = '::ListStatus::' WHERE (Key = ::Key:"
>
> Sorry, it is a long one.
> --
> samG
>
>
> "Kevin Spencer" wrote:
>
>> 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.
>>
>> "samG" <(E-Mail Removed)> wrote in message
>> news:A2716E22-55CD-4752-B8B2-(E-Mail Removed)...
>> > 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
>> >
>> >
>> > "Kevin Spencer" wrote:
>> >
>> >> Hi Sam,
>> >>
>> >> "samG" <(E-Mail Removed)> wrote in message
>> >> news:32D1B98E-31BB-478C-B6D0-(E-Mail Removed)...
>> >> > 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.
>> >>
>> >>
>> >>
>>
>>
>>

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" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:FF5980AB-985F-434A-B0FF-(E-Mail Removed)...
> > 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 = ':ateListed::' , DateSold =
> > ':ateSold::' , FinalPrice = ::FinalPrice:: , Concessions =
> > '::Concessions::' , ListStatus = '::ListStatus::' WHERE (Key = ::Key:"
> >
> > Sorry, it is a long one.
> > --
> > samG
> >
> >
> > "Kevin Spencer" wrote:
> >
> >> 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.
> >>
> >> "samG" <(E-Mail Removed)> wrote in message
> >> news:A2716E22-55CD-4752-B8B2-(E-Mail Removed)...
> >> > 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
> >> >
> >> >
> >> > "Kevin Spencer" wrote:
> >> >
> >> >> Hi Sam,
> >> >>
> >> >> "samG" <(E-Mail Removed)> wrote in message
> >> >> news:32D1B98E-31BB-478C-B6D0-(E-Mail Removed)...
> >> >> > 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.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>