>Hi, > >This is supported in the current version. See >http://www.h2database.com/html/grammar.html#update > >UPDATE tableName SET {columnName= {DEFAULT | expression} } [,...] >[WHERE expression]
OK, I missed it. Sincere apologies for the waste of everyone's time and bandwidth :-) Excellent news, I had really been wondering how I could simulate it without making a new record... >> but this isn't working in my version of h2 (2006-08-31). > >That's a very old version. > >> I have just downloaded the 2009-09-04 version of h2, but the SQL >>syntax doesn't >> show any change to the UPDATE command > >I think it does. See above. Many thanks :-) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
