Hello Mark,
it is very simple, I know. But sometimes...
Thank you very much, best regards.
Olaf

On 4-11-2013 15:52, checkmail wrote:
>
>
> Hello,
>
> I would update a table (Primary key year and number), all records with
> the same ordernumber for example - but not the record where is
> currently in use and already updatet.
>
> Update table set field = value where ordernumber = XXX and (not record
> with year 2013 and Number 1)

You just need to use the right syntax for the condition:

Update table set field = value
where ordernumber = XXX
and not (year = 2013 and Number = 1)

Mark
--
Mark Rotteveel


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo Groups Links