db.Open("db1", FALSE, FALSE, "ODBC;",
db.ExecuteSQL("INSERT INTO [table2] SELECT * FROM [table1] WHERE [table1].[Students_named] = 'Anjing'");
db.ExecuteSQL("DELETE FROM [table1] WHERE [table1].[Students_named] = 'Anjing'");
My question is :
Is it possible for me to to get the number of records from a table based on a criteria and then use that value to updata the record found in another table. Is it possible to do that like the sample above using ExecuteSQL statement.
Table A has 10 records.
Table B has 1 row that keeps track of the number of record in Table A within a single row.