Maureen:
Date is a Microsoft Jet 4.0 reserved word:
http://support.microsoft.com/?id=321266 Try change Date to myDate in
your
database, reimport the database into your web and rerun the DBIW.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
The update.asp page includes the following:
fp_sQry="UPDATE Email SET First = '::First::' , Last = '::Last::' ,
Company
= '::Company::' , Email = '::Email::' , Phone = ':
hone::' , Date =
':
ate::' , SalesRep = '::SalesRep::' WHERE (ID = ::ID:
"
fp_sDefault="First=&Last=&Company=&Email=&Phone=&Date=&SalesRep=&ID=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="emaildb"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&First=202&Last=202&Company=202&Email=202&Phone=202&Date=135&SalesRep=202&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
All fields in the database have the AllowZeroLength property set to
YES -
except the Date field which does not have that property - all records
have
the date field populated.
I hope this is helpful to you in your efforts to help me get this to
work.
THANK YOU!
:
THe DBI was created through FP's DBIW - I did not customize anything.
The
MS Access table in this DBI contains an autonumber ID field set as the
primary key, 6 text fields and 1 date/time field. One of the text
fields
is
currently blank for all records but it will get populated in the near
future.
This is an incredibly simply table. All fields are included in the
DBI.
I
have deleted and recreated the DBI a few times, with and without the
submission and results pages and the edits are the only feature not
working.
Sorry, I'm unsure what the UPDATE statment is. There is noting with
the
word
update on the DB Editor page.
This same web does have another DBI - that one was created a long time
ago
and is working. I recall having a similar problem, edits not working,
but
eventually was lucky enough to delete and recreate the DBI enough
times
to
get a version that worked.
I'm at a loss - any suggestions??
:
Post the UPDATE statement you are using and the type of fields in
your
DB in the Update
--
_____________________________________________
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
_____________________________________________
|I populated the one blank field in the record I tried to edit and
got
the
| following:
|
| Database Results Error
| Description: Syntax error in UPDATE statement.
| Number: -2147217900 (0x80040E14)
| Source: Microsoft JET Database Engine
|
|
| Any tips or pointers in the right direction will be most
appreciated!
|
|
| "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/
| > FrontPage Support:
http://www.frontpagemvps.com/
| >
| >
| >
| >
message
| > | > > Error simply displays as follows:
| > >
| > > Database Results Error
| > > The operation failed. If this continues, please contact your
server
| > > administrator.
| > >
| > > "MaureenKLM" wrote:
| > >
| > >> FP 2002 - SP3 - with Access 2002 DB -
| > >>
| > >> Created the DBI electing all 3 pages (submission, results &
editor) into
| > >> an
| > >> existing web - working live on the server.
| > >>
| > >> The add/deletes work but I can not EDIT existing records - I
know this is
| > >> not too uncommon of a problem but I don't know the solution -
help
| > >> pelase!
| >
| >
| >
