Thanks a lot 😊
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Donnerstag, 15. Juni 2017 15:42 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] increment It is possible to do this with a complex, but straight UPDATE statement. However, my hunch is that the below is simpler: execute block as declare variable i integer; declare variable PK <whatever>; i = 1; for select <PrimaryKey> from table where year = 2010 order by month, <PrimaryKey> into :PK do begin update table set "POS" = i where <PrimaryKey> = :PK; i = i + 1; end end HTH, Set 2017-06-15 15:33 GMT+02:00 'Check_Mail' mailto:check_m...@satron.de [firebird-support] <mailto:firebird-support@yahoogroups.com>: Hello, How can I increment consisting records like this: Year month order pos 2010 2 1 null 2010 2 1 null 2010 2 1 null 2010 3 2 null Pos should be auto increment for all 2010 2 records, null to 1, the second record null to 2 til 4 Update table set pos = coalesce(pos,0)+1 where year = 2010 and month = 2 works not, all records have the pos=1 value Thank you Best regards Olaf ------------------------------------ Posted by: "Check_Mail" <mailto:check_m...@satron.de> ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links