FPDB: Parameter Update Not Working When Non-Param Works

[Mike Plagge]

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=':Title::' ,
Contact='::Contact::' , Phone=':hone::' ,
BuildingLevel='::BuildingLevel::' ,Keyword1='::Keyword1::' ,
Keyword2='::Keyword2::' , Keyword3='::Keyword3::' , Plan1=':lan1::' ,
Plan2=':lan2::' , Plan3=':lan3::' , Do=':o::' , 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.

 

[Mike Plagge]

I'm also getting this same message now for a search. Nothing on the search
has changed. Could it be a permissions issue?