TMStable.SQLDelete Again
if you leave empty delete code in update SQL tab.... you using TMsTable as simple as standard TTable......
f.e. MyTable: TMsTable .......... if you put MyTable.Delete in the code ... the current record will be deleted.
But if you think about delete code in update SQL tab ..... i think you telling about TMsQuery rather than TMsTable.
If you leave it empty it works the same way as TMsTable.
In this area you can insert any SQL code which be executed by server when you need delete record. Remember, that it's SQL (not pascal) code.
If you need detailed story how it's work send me an email described what is your problem.
f.e. MyTable: TMsTable .......... if you put MyTable.Delete in the code ... the current record will be deleted.
But if you think about delete code in update SQL tab ..... i think you telling about TMsQuery rather than TMsTable.
If you leave it empty it works the same way as TMsTable.
In this area you can insert any SQL code which be executed by server when you need delete record. Remember, that it's SQL (not pascal) code.
If you need detailed story how it's work send me an email described what is your problem.
for delete some records in one time please use TMsSQL component....
f.e. MySQL: TMsSQL;
MySQL.SQL.Text := 'DELETE FROM table_name WHERE Country = ''Poland''';
MySQL.Execute;
in this moment all records where field Country contents 'Poland' will be deleted.
but ..... Don't forget to REFRESH any table or query using table_name in
f.e. MySQL: TMsSQL;
MySQL.SQL.Text := 'DELETE FROM table_name WHERE Country = ''Poland''';
MySQL.Execute;
in this moment all records where field Country contents 'Poland' will be deleted.
but ..... Don't forget to REFRESH any table or query using table_name in