Hi all,
I have been using the raw SQL plugin to import data from FileM**** into tables in PostgreSQL. These tables are created when needed so I can do data cleaning using SQL queries. My Servoy module writes these queries for me and they run very, very fast. I just have to sit back and snap my fingers 
while I watch a progressbar fly across the screen…
It all works great until I want to save a list of errors messages in a normal table that Servoy is aware of. Servoy does not know about the table so I can’t use the DatabaseManager. I want inform the user of the data quality before importing the data into the ‘real’ tables. I want to avoid a Servoy restart at this point.
I can generate all the errormessages using the rawSQL plugin, but there is no way of getting a dataset from the plugin…
As I write this I realize that I can probably get the rawSQL plugin to write to a file and read that back in, but it feels a bit like a work-around
:shock:
Anyone with better solutions?