How to update a few records in a big TPS table? Solved

[Mike_Duglas]

You can perform a sql command against tps database:

SQL access to TPS databases without ODBC driver

Here is standard SCHOOL application demonstrating a possibility to SQL access to TPS databases. Just run school.exe, there are 2 items under “SQL” menu: “Browse Teachers with SQL filter” and “Arbitrary SQL Queries”. First item opens Teachers browse and allows to filter like t.LastName LIKE(‘C%’) AND m.Description IN(‘Law’, ‘Sociology’) where t and m are aliases for Teachers and Majors tables, respectively. Second item allows to execute any arbitrary SELECT statement against entire database…