Topic: [Solved] Delete only specified field from db table
Hi all,
Example: there is table emplyees with fields first_name and last_name in it. Is it possible on button click (with script) to delete only specified last_name but first_name needs to stay (i dont't want to delete whole row - record). Basically what I need is to delete only last name of specified person on button click. I tried something like this but it doesn't work:
SQLExecute('DELETE from employees WHERE last_name.id =' +Form1.tablegrid1.sqlvalue);
SQLExecute('DELETE last_name from emplyees WHERE last_name.id =' +Form1.tablegrid1.sqlvalue);
Is it possible and if it is, all I need is syntax.
Thanks in advance,
Vladimir