I am using an In-Memory SQite file as a cache/holder for table rows before being uploaded to Postgres.
However I a having difficulty reading the memory file.
lineitemTableView.dataSet = SQLiteDatabase1.rows
var rs = lineitemTableView.dataSet;
var count = rs.rowCount; // count = 0 , should be 3
where count gives 0 instead of 3 - (verified as seen in the screen shot) .
This particular code was tested on its own successfully before being included in the project .
Is there a 'more' specific way of pointing to the SQlite memory file when there are other db files in the project ?
Any suggestions are appreciated.