FP2003 Database Update query problem

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I've used the DRW to generate a page which updates a
table. It just will not work - I've cut the query down to
this:
UPDATE tblItem SET ItemName ="Name" WHERE ItemId
= ::ItemId:: but it still will not work. I know that
there is a value in ::ItemId:: because on the same page I
have another DRW which retrieves sn Item based on that
Id. Is there a generic problem with updating tables in
FP? If I change ::ItemId:: to a number then the update
query works, but that's not a great deal of use.

Any ideas?
 
Sorry
That was wrong it should be
UPDATE tblItem
SET ItemName='::Name::'
WHERE Itemid=::Itemid::
/Ted
 
Sorry
That was wrong, it should be
UPDATE tblItem
SET ItemName='::Name::'
WHERE Itemid=::Itemid::
/Ted
 
Sorry
That was wrong, it should be
UPDATE tblItem
SET ItemName='::Name::'
WHERE Itemid=::Itemid::
/Ted
"Ray" <
microsoft.public.frontpage.client
 
Ted
I appreciate your replies, but that is what I had, but it
won't work. What I was trying to say was that if I
replace '::Name::' with the literal "Name" and ::ItemId::
with 2, for example, then it will work. But I can't get it
to work with the parameters that you suggest, even though
I know for sure that they both have data.
 
I had the same problem with FP2003 and update so I did those pages with
FP2000 and then it worked. Every time I have to change anything with the
dbresult on those pages I have to use FP2000 otherwise I get error.
/Ted
 
Back
Top