I see that the TDataSet class has an AutoCalcFields property. But I have no idea if it works or not, or how to use it.
I want to use a Select-SQL Query which uses a field named "realcount" which is defined using a Delphi function. The Delphi function needs a "filename" field from the SQL Query, and then the Delphi function returns "realcount" to the SQL Query. So for example, this table
filename count somedata
'test1.txt' 5 'just some data'
'test2.txt' 7 'another piece of data'
Using the SQL-query "select filename, count, realcount from mytable" I want a Delphi function to open the file named filename, and scan that file to check the "realcount" value which will be returned in the SQL-query.
Is there somehow to do this using any kind of Database? (I'm using SQLite right now, but I'm open for changes)