Hello all!
I need to fill a matrix object with the result of an arbitrary query. I have read that in the currect verison of SBO this can be done via DataSources.DataTables, but what about version 2004?
It has only User- and DBDataSources. The former ones are way too slow, and the latter ones require a link to a real DataBase table. If I understand correctly, this referenced table must be either a standard SBO table or an SBO user table, which means I cannot quickly create a #temporary table on the fly and used it to transfer data to the matrix.
Plus there's another problem: as distinct from SBO DataTables, the table referenced by a DBDataSource is server-based and it will be common for all the instances of the form on all the clients.
So, what are the possible solutions?
Thanks in advance,
Anton