DecSoft Support - Loading an array from javascript results variable containing SQLite query

Loading an array from javascript results variable containing SQLite query

Design for small screen devices but deploy also (without changes) in larger devices like tablets.

Save money by purchasing our NeoPlugins bundles. Five, Ten and even the complete NeoPlugins collection at an incredible price!

DecSoft NeoPlugins put your VisualNeo projects into another level with +1,000 new actions for your apps.

DecSoft NeoPlugins are available in both runtime and designtime flavours to keep your apps as small as possible.

Create apps and expand their capabilities by using the world's popular programming language: Javascript.

DecSoft HTML Compiler include a convenient Command Line Compiler, so you can compile your apps from the console.

Apache Cordova's official plugins are supported out of the box and there are hundreds of plugins ready to use.

Take a look at some frequently asked questions about us and our products!

Create modern HTML apps and games at another level making things impossible to do even by modern HTML apps and games.

DecSoft App Builder include a convenient Command Line Compiler, so you can compile your apps from the console.

Compile, convert your modern HTML apps and games into Microsoft Windows executable programs without dependencies.

Take a look at our YouTube channel and subscribe to be notified about new videos!

Save time, resources and money creating apps for Android, iOS and more with the same base of code.

DecSoft HTML Compiler is easy to use: set your project's options and compile your apps and games in a nutshell.

Create multiplatform apps with DecSoft App Builder, including Android and iOS with the same base of code.

DecSoft App Builder integrates an Open AI assistant in order to assist you while developing your apps.

Ryan Sytsma

I have the below code to query a SQLite database when the app is offline.

StartJS
var db = window.sqlitePlugin.openDatabase({
	name: 'pts.db3',
	location: 'default',
	androidDatabaseProvider: 'system'
	});

	db.transaction(function(tx){
	    tx.executeSql('SELECT * FROM dailycrew', [], function(tx, results){
        window.App.RootScope.dailyCrews = results;
        });
		});

	db.close(function () {
		console.log("DB closed!");
	}, function (error) {
		console.log("Error closing DB:" + error.message);
	});
EndJS

NewArray "arrDailyCrews"

The results JS variable is an array of records.

I want to take "window.App.RootScope.dailyCrews = results;" and set "dailyCrews" to the NewArray "arrDailyCrews".

Is that needed or can I just use "window.App.RootScope.dailyCrews" as my array on the AB code side?

DecSoft

Hello Ryan,

If I am understand well, what you asked is if the NewArray action is required. If so, in principle, it's not required, that is, you can create the Array variable just by assigning the "result" variable into "window.App.RootScope.dailyCrews", just like you do now.

However, certainly in some situations we need to declare a variable before can use it, for example, inside app functions. So maybe it's not a bad idea to use the "NewArray" action in the app Ready event, or the app view Show event.

Purchase one or more licenses of our products if they are useful to you!

Ryan Sytsma

Thank you David

If I do decide to use NewArray "arrDailyCrews" do I need to loop "window.App.RootScope.dailyCrews" to fill the new array or is it just a direct assignment?

Everybody can read the DecSoft support forum for learning purposes, however only DecSoft customers can post new threads. Purchase one or more licenses of some DecSoft products in order to give this and other benefits.