Default value not applied

[Middlemarch]

I've added a numeric field to my table and set a default value.
But the records don't change to this value. Should they ?

[pbaldy]

Only new records have the default value applied, not existing records. You could run an update query to update existing records.

[Middlemarch]

Thanks for putting me straight and update query sorted it.

[pbaldy]

No problemo.