FPDB: Parameter Update Not Working When Non-Param Works

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mike Plagge (mwplagge_at_hotmail.com)
Date: 05/03/04 

Date: Mon, 3 May 2004 10:23:01 -0500

Using FP 2003 and 2002. I'm using the DB Wizard. I have an update query
that uses parameters to pass information from a form to the dbrw. The
update was working fine. In fact, it still works fine if I put the values
in.

Here are the two queries:

update pdsaprojects set building='::building::' , PTitle='::PTitle::' ,
Contact='::Contact::' , Phone='::Phone::' ,
BuildingLevel='::BuildingLevel::' ,Keyword1='::Keyword1::' ,
Keyword2='::Keyword2::' , Keyword3='::Keyword3::' , Plan1='::Plan1::' ,
Plan2='::Plan2::' , Plan3='::Plan3::' , Do='::Do::' , Study='::Study::'
, Act1='::Act1::' , Act2='::Act2::' , StartDate=#::StartDate::#, user =
'::users::' where id=::id::

update pdsaprojects set building='arthur' , PTitle='title' ,
Contact='contact' , Phone='555' , BuildingLevel='elem' ,Keyword1='keyword1'
, Keyword2='Keyword2' , Keyword3='Keyword3' , Plan1='Plan1' ,
Plan2='Plan2' , Plan3='Plan3' , Do='Do' , Study='Study' , Act1='Act1' ,
Act2='Act2' , StartDate=#5/2/2004#, user = 'mplagge;tbarschow;' where
id=22

The second one works. The first one gives an error message of:
Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

I do not get any message about a missing parameter (which you usually get if
your parameter names don't match form field names), missing operator, or
missing id. This is the first time I've seen this message and I've created
hundreds of update pages just like this. The query was working on Friday.

Does anyone have any suggestions?
Thanks.

Relevant Pages

  • Re: Query results and Update Query In forms
    ... On the second form I need to redisplay the data entered on the first form and and the next 5 fields that now require imput. ... My update query is validating fine within the wizard but creats a new recordset and in some cases is entering the old and new values in the same dbase field in my table. ...
    (microsoft.public.frontpage.programming)
  • Re: Cannot add users to AD
    ... > were missing from System32. ... > Wizard could not create the user, click OK to cancel the wizard". ... > fancy another 30 mile drive to do a restore!) ... Eriq Neale - MCSE, MCSA Messaging, MCP Small/Medium Business, Mac Guru ...
    (microsoft.public.windows.server.sbs)
  • Re: New version of lcc-win
    ... The next error came up if I tried to generate a simple project with help of the wizard: ... --- Prototype for difftimemissing in time.h ... The installation ran as usual, the libraries have been built but if I ...
    (comp.compilers.lcc)
  • RE: Button for Open report by Wizard missing Docmd code.
    ... embedded macro not VBA for the operation. ... I use the wizard ... Once on my form, I expect the button to open my report, but it does nothing. ... I checked the VB code and it is missing the Docmd statement, ...
    (microsoft.public.access.forms)
  • Re: brand new here
    ... Takeadoe wrote: ... I'm at the entry level right now, ... (it was missing in the source). ... update query to change the null values to 2005 ...
    (comp.databases.ms-access)