The table field name is ' Item' and the following SQL works OK

UPDATE "TabletInvoice" SET
"Qty" = :Qty
WHERE "TabletID" = :TabletID  AND "Item" = :Item

However if I do the following

UPDATE "TabletInvoice" SET
"Qty" = :Qty
WHERE "TabletID" = :TabletID  AND "Item" = :DuplicateItem

I get the error 'No update record found'

Is this a bug If not why

Thanks

Michael

Can you start at the beginning and describe the steps that you are taking?

I am guessing that you are in the Servers Manager, selected a Server, then selected a database. Is this correct? Then you have selected a dataset and you are now viewing the UDPATE SQL which looks something like

UPDATE "StockCategories" SET
"ID" = :ID,
"Name" = :Name
WHERE "ID" = :Old_ID

Is this correct or am I completely missing the point?

Richard

You are correct. This is the code that references the UPDATE

      TabletInvoice.Params.Values['TabletID']:= TabletID;
      TabletInvoice.Params.Values['Item']:= Item;
      Database.LoadRows(TabletInvoice);

      TabletInvoice.Columns['Item'].SortDirection:=sdAscending;
      TabletInvoice.SortCaseInsensitive:=True;
      TabletInvoice.Sort;

      if TabletInvoice.Find(['Item'],[Item],False,True) then
        begin
         TabletInvoice.update;
         TabletInvoice.Columns['Qty'].AsInteger := TabletInvoice.Columns['Qty'].AsInteger + AddedQty;
         TabletInvoice.save;
         Database.Commit;
         Request.SendContent('Duplicate Item  updated');
        end

Michael,

<< However if I do the following

UPDATE "TabletInvoice" SET
"Qty" = :Qty
WHERE "TabletID" = :TabletID  AND "Item" = :DuplicateItem

I get the error 'No update record found' >>

EWB 3 requires that the parameter names match the names of the columns being updated (that's how EWB knows to populate the parameter).

Is there actually a column called "DuplicateItem" in the table being updated ?

Tim Young
Elevate Software
www.elevatesoft.com

Is there actually a column called "DuplicateItem" in the table being updated ?

No there is not  What confused me is when I generate the UPDATE command automatically using the  IDE  eg

WHERE "Account" = :Old_Account

maybe should be

WHERE "Account" = :Account