Open a window into your DB (data adapter, or whatever), and use the SQL
You could do something simple like this with a command objectâs .ExecuteScalar() function.
To get your app to update, the resource-economical way to do this is with an OnUpdate (or AfterUpdate, whatever) trigger in the database that then "tickles" your app. If the DB can receive the address of a function, and then call that function using the address, that would be the ticket.
Outside a database environment, this would be a callback process.
A far less efficient way is to go âinspectâ the DB on a timed basis.