Re: Data Base Interface Wizard update problem
From: Thanasis \(sch\) (thanasis_gr_at_hotmail.com)
Date: 01/14/05
- Next message: Kathleen Anderson [MVP - FrontPage]: "Re: my site doesnt publish even though everything looks right and i a."
- Previous message: atkandbck: "my site doesnt publish even though everything looks right and i a."
- In reply to: Paul M: "Re: Data Base Interface Wizard update problem"
- Next in thread: Paul M: "Re: Data Base Interface Wizard update problem"
- Reply: Paul M: "Re: Data Base Interface Wizard update problem"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 14 Jan 2005 03:04:01 +0200
Hi,
thanks again.
Excuse me what do you mean by timestamp field?In my access database i need a
field of type date/time in order to store the date
of an article?If i remove this field how could i store the date?Must i add a
separate field with type timestamp?
I think that access doesn't have such a type(timestamp) !!!It only has a
type called date/time
Could you please explain?
Thanasis
"Paul M" <P@doinghisbest> wrote in message
news:OSxiRJZ%23EHA.2596@tk2msftngp13.phx.gbl...
> Correction : by time/date I mean timestamp field
> paul m
> "Thanasis (sch)" <thanasis_gr@hotmail.com> wrote in message
> news:u9e1ipY%23EHA.1260@TK2MSFTNGP12.phx.gbl...
>> hi thanks a lot,
>> i tried it but doesn't work.Maybe the autonumber field causes the
>> problem.
>> I can't provide an initial value for it.
>> DIW causes many problems.
>>
>> thanks again
>>
>>
>>
>> "Paul M" <P@doinghisbest> wrote in message
>> news:OHG1N0X%23EHA.936@TK2MSFTNGP12.phx.gbl...
>> > Hi Thanasis
>> > I had the same problem. It seems the update won't update empty database
>> > fields. I got over it by:
>> > Opening the database in Access(double click the database in the fpdb
>> > folder.
>> > open the table where the data is stored.
>> > In Access click the view button on the left and in the default value
> pane
>> > at
>> > the bottom type something like "No Details" (don't forget the "
> marks)and
>> > put a 0 in the number fields.
>> > Do this for all the fields of your database
>> > By doing this a value is added to the field as a default until it is
>> > populated by an entry from your form.
>> > Hope this helps
>> > Best wishes
>> > Paul M
>> > "Thanasis (sch)" <thanasis_gr@hotmail.com> wrote in message
>> > news:eaORDhX%23EHA.2680@TK2MSFTNGP09.phx.gbl...
>> >> Hi to everyone,
>> >>
>> >> i use FP2003 DIW feature to manage my database (add,delete,update).
>> >>
>> >> My access database has the following fields:
>> >>
>> >> article_id(autonumber)
>> >> article_title(text)
>> >> article_date(date/time) with default value now()
>> >> article_body(memo)
>> >> link1(hyperlink)
>> >> link2(hyperlink)
>> >> image(text)
>> >>
>> >>
>> >> Everything(i.e add,delete) works fine except for update operation.
>> >>
>> >> When i'm trying to update my database i get the following error
> message:
>> >>
>> >> Database Results 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.
>> >>
>> >>
>> >> I provide below the FP2003 generated code inside update.asp
>> >>
>> >> Thanks in advance
>> >> thanasis
>> >>
>> >>
>> >>
>> >> <!--webbot bot="DatabaseRegionStart"
>> >>
>> >
> s-columnnames="article_id,article_date,article_title,artcile_body,link1,link
>> > 2,image"
>> >> s-columntypes="3,135,202,203,203,203,202" s-dataconnection="news"
>> >> b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue
>> >> b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
>> >> b-listlabels="FALSE" b-listseparator="FALSE" i-ListFormat="0"
>> >> b-makeform="FALSE" s-RecordSource s-displaycolumns s-criteria s-order
>> >> s-sql="UPDATE news SET article_date = '::article_date::' ,
> article_title
>> >> =
>> >> '::article_title::' , artcile_body = '::artcile_body::' , link1 =
>> >> '::link1::' , link2 = '::link2::' , image = '::image::' WHERE
>> >> (article_id
>> > =
>> >> ::article_id::)" b-procedure="FALSE" clientside SuggestedExt="asp"
>> >>
>> >
> s-DefaultFields="article_date=&article_title=&artcile_body=&link1=&link2=&im
>> > age=&article_id=0"
>> >> s-NoRecordsFound="Record updated in table." i-MaxRecords="1"
>> > i-GroupSize="0"
>> >> u-dblib="../../../_fpclass/fpdblib.inc"
>> >> u-dbrgn1="../../../_fpclass/fpdbrgn1.inc"
>> >> u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan
> BOTID="0"
>> >> preview="<table border=0 width="100%"><tr><td
>> >> bgcolor="#FFFF00"><font
> color="#000000">This
>> > is
>> >> the start of a Database Results region. The page must be fetched from
>> >> a
>> > web
>> >> server with a web browser to display correctly; the current web is
> stored
>> > on
>> >> your local disk or
>> >>
> network.</font></td></tr></table>" --><!--#include
>> >> file="../../../_fpclass/fpdblib.inc"-->
>> >> <% if 0 then %>
>> >> <SCRIPT Language="JavaScript">
>> >> document.write("<div style='background: yellow; color: black;'>The
>> > Database
>> >> Results component on this page is unable to display database content.
> The
>> >> page must have a filename ending in '.asp', and the web must be hosted
> on
>> > a
>> >> server that supports Active Server Pages.</div>");
>> >> </SCRIPT>
>> >> <% end if %>
>> >> <%
>> >> fp_sQry="UPDATE news SET article_date = '::article_date::' ,
>> >> article_title
>> > =
>> >> '::article_title::' , artcile_body = '::artcile_body::' , link1 =
>> >> '::link1::' , link2 = '::link2::' , image = '::image::' WHERE
>> >> (article_id
>> > =
>> >> ::article_id::)"
>> >>
>> >
> fp_sDefault="article_date=&article_title=&artcile_body=&link1=&link2=&image=
>> > &article_id=0"
>> >> fp_sNoRecords="Record updated in table."
>> >> fp_sDataConn="news"
>> >> fp_iMaxRecords=1
>> >> fp_iCommandType=1
>> >> fp_iPageSize=0
>> >> fp_fTableFormat=False
>> >> fp_fMenuFormat=False
>> >> fp_sMenuChoice=""
>> >> fp_sMenuValue=""
>> >>
>> >
> fp_sColTypes="&article_id=3&article_date=135&article_title=202&artcile_body=
>> > 203&link1=203&link2=203&image=202&"
>> >> fp_iDisplayCols=16
>> >> fp_fCustomQuery=True
>> >> BOTID=0
>> >> fp_iRegion=BOTID
>> >> %>
>> >> <!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
>> >> <!--webbot bot="DatabaseRegionStart" endspan i-checksum="12627" -->
>> >>
>> >>
>> >
>> >
>>
>>
>
>
- Next message: Kathleen Anderson [MVP - FrontPage]: "Re: my site doesnt publish even though everything looks right and i a."
- Previous message: atkandbck: "my site doesnt publish even though everything looks right and i a."
- In reply to: Paul M: "Re: Data Base Interface Wizard update problem"
- Next in thread: Paul M: "Re: Data Base Interface Wizard update problem"
- Reply: Paul M: "Re: Data Base Interface Wizard update problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
