In Memory Datasource does not show after creation

Questions
1

Hi there,

I’m trying to create an in Memory table of some temperature measurements in order to work on the data before passing it into a foundset. However after creating the in Memory table with an sql query it does not show in the solution explorer. The console does not show any error, the sql query works, the parameters are set correctly. What am I doing wrong? I’m simply using:

databaseManager.createDataSourceByQuery('mem_myTempTable','server3', sql, params, maxRows);

Thanks for any suggestions.

Cheers

Alex

2

Hi,

In memory tables that are created at runtime will never show up in the Solution Explorer.
Only if you create the table at design time, this will be the case.

Hope this helps

3

Hi!

If you save the in memory table as a variable, you can operate on it as a foundset. See the docs → here.

In your case it would be:

var uri = databaseManager.createDataSourceByQuery('mem_myTempTable','server3', sql, params, maxRows);
var fs = databaseManager.getFoundSet(uri)

Cheers,

Alex.