Recent

Author Topic: SQLQuery Update on whole record  (Read 2229 times)

TRon

  • Hero Member
  • *****
  • Posts: 525
Re: SQLQuery Update on whole record
« Reply #15 on: June 27, 2020, 05:01:51 pm »
ah ok. Thank you for that explanation erictan as i didn't know that. That's pretty dumb if you ask me. That would be a unworkable situation for a remote db. e.g. that seems to suggest there must be a better way....

rvk

  • Hero Member
  • *****
  • Posts: 4479
Re: SQLQuery Update on whole record
« Reply #16 on: June 27, 2020, 05:03:45 pm »
I would thought that like 'select * from table' which extract all fields with having to specify all the fields individually, SQLQuery.Update or Insert would have similar feature instead of having to specify each Field-Value pair.
You don't have to specify each field value pair with .edit.
You can just change the field you want to change.
If you are worried about speed, this is still very fast and the easiest way.
Otherwise you can follow Trons suggestion to create a separate sql.update but that's more work. It's up to you. Otherwise I'm not sure your explaining your problem correctly.

 

TinyPortal © 2005-2018