1 Topic by v_pozidis (edited by v_pozidis 2021-08-16 18:57:14)

  • Registered: 2014-09-06
  • Posts: 805

Topic: New record in table

Hi all, I have add a new record  in an existing table(Boolean type) and I face a problem. How can I use the existing values from the records (from  the old one) in my new software ? I like to place False value in the new column for all the records.

  • From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

Re: New record in table

try this query to apply false value for all stored rows in specified table ...

sqlexecute(update tablename set columnnameboolean = '0' where id > 0)