Posts by Ryan Sytsma

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

Show threads by Ryan Sytsma

109 posts found, page 2 of 8

Ryan Sytsma (In thread: Problems to register AB1 release 2019.56)

I upgraded to 2019.56 today, and the AB install need to be registered again. I entered my Username and Serial number but the credentials are not getting saved. 2019.56 continues to show "Unregistered"

Ryan Sytsma (In thread: Watcher and sequencing javascript)

I deleted the Cache and Compiled folders just in case something is not compiling clean. Now the output in the console is this. I am not sure what this means.

ANDROID_HOME=C:\Users\ryans\AppData\Local\Android\Sdk (DEPRECATED)
No target specified, deploying to device 'DTFGSKR2F1'.
Using apk: C:\Sync\Ryan\GitHub Repos\PTS Mobile\PTS_Compiled\platforms\android\app\build\outputs\apk\debug\app-debug.apkPackage name: com.ptsapp.ptsmobile
LAUNCH SUCCESS
12-01 13:33:33.947 13343 13343 D CordovaWebViewImpl: onPageFinished(file:///android_asset/www/index.html#!/Home)
12-01 13:33:34.029 13343 13343 D SystemWebChromeClient: file:///android_asset/www/cordova.js: Line 1739 : Could not find cordova.js script tag. Plugin loading may fail.
12-01 13:33:34.042 13343 13343 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 389 : Error: [$templateRequest:tpload] http://errors.angularjs.org/1.7.8/$templateRequest/tpload?p0=app%2Fviews%2FHome.html&p1=-1&p2=

Ryan Sytsma (In thread: Watcher and sequencing javascript)

All of the samples and documents for this plugin use "tx" or "transaction" inside of the db.transaction callback.

https://github.com/brodybits/cordova-sqlite-test-app

https://github.com/xpbrew/cordova-sqlite-storage#sample

I built this test app using AB 2020 as detailed in this link, and it also did not work. ( https://github.com/brodybits/cordova-sqlite-test-app/blob/master/www/app.js ). The only feedback I get from the console is that the database is waiting to close after I issued a close command. It seems like something is not getting released by the plugin.

Offline data is critical to this app... I have to get this or another offline solution working.

Ryan Sytsma (In thread: Watcher and sequencing javascript)

David, I got the ABD working. It is very helpful.

So, here is something interesting. I got this code to work when the first view event "Show" fires.

var db = null;
document.addEventListener('deviceready', function() {
var db = window.sqlitePlugin.openDatabase({ name: 'pts.db', location: 'default' });
db.transaction(function(tx) {
         tx.executeSql("CREATE TABLE IF NOT EXISTS tracking (tbl, action, id)");
         tx.executeSql("INSERT INTO tracking (tbl, action, id) VALUES ('test', 'test', '1')");
         console.log("sqlinit created and inserted tracking table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS activitycode (id, activity_code, activity_description)");
         console.log("sqlinit created activity code table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS position (id, code, description)");
         console.log("sqlinit created position table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS users (id, user_name, user_level)");
         console.log("sqlinit created users table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS customer (id, customer_name)");
         console.log("sqlinit created customer table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS contract (id, contract_name, is_active)");
         console.log("sqlinit created contract table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS contracttask (id, contract_id, task_number, task_status, date_complete, crew_comments, completed_crew_id, mobile_create, mobile_update)");
         console.log("sqlinit created contract task table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS dailycrew (id, crew_date, crew_start, crew_end, note, crew_hours, server_create, server_update, mobile_create, mobile_update, user_create, user_update)");
         console.log("sqlinit created daily crew table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS dailycrewemployee (id, daily_crew_id, user_id, employee_position, user_start, user_end, mobile_create, mobile_update, user_create, user_update)");
         console.log("sqlinit created daily crew employee table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS dailycrewactivity (id, daily_crew_id, activity_date, contract_task_id, activity_code, activity_start, activity_end, activity_hours, mobile_create, mobile_update, user_create, user_update)");
         console.log("sqlinit created daily crew activity table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS viewtaskvaluedisplay (id, contract_id, task_id, label_text, value_display, value_order)");
         console.log("sqlinit created task value display table");
         console.log("all tables have been created");
    },
function(error) {
window.alert('Open database ERROR at Sqlinit ' + error.message);
},
function(){
console.log("success");
});
});

and here is the output of the console window...

LAUNCH SUCCESS
11-29 22:10:04.070 32253 32253 D CordovaWebViewImpl: onPageFinished(file:///android_asset/www/index.html#/)
11-29 22:10:05.522 32253 32253 D SystemWebChromeClient: file:///android_asset/www/plugins/cordova-sqlite-storage/www/SQLitePlugin.js: Line 175 : OPEN database: pts.db
11-29 22:10:05.536 32253 32253 D SystemWebChromeClient: file:///android_asset/www/plugins/cordova-sqlite-storage/www/SQLitePlugin.js: Line 106 : new transaction is queued, waiting for open operation to finish
11-29 22:10:05.563 32253 32253 D SystemWebChromeClient: file:///android_asset/www/plugins/cordova-sqlite-storage/www/SQLitePlugin.js: Line 179 : OPEN database: pts.db - OK
11-29 22:10:05.566 32253 32253 D SystemWebChromeClient: file:///android_asset/www/plugins/cordova-sqlite-storage/www/SQLitePlugin.js: Line 80 : DB opened: pts.db
11-29 22:10:05.570 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 885 : sqlinit created and inserted tracking table
11-29 22:10:05.580 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 887 : sqlinit created activity code table
11-29 22:10:05.583 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 889 : sqlinit created position table
11-29 22:10:05.586 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 891 : sqlinit created users table
11-29 22:10:05.588 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 893 : sqlinit created customer table
11-29 22:10:05.591 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 895 : sqlinit created contract table
11-29 22:10:05.594 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 897 : sqlinit created contract task table
11-29 22:10:05.599 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 899 : sqlinit created daily crew table
11-29 22:10:05.602 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 901 : sqlinit created daily crew employee table
11-29 22:10:05.607 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 903 : sqlinit created daily crew activity table
11-29 22:10:05.612 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 905 : sqlinit created task value display table
11-29 22:10:05.615 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 906 : all tables have been created

However, after this JS code finishes, no other code will run. Even code I put into the success callback such as this...

tx.executeSql('SELECT count(*) AS mycount FROM tracking', [], function(rs) {
console.log(rs.rows.item(0).mycount);
});

...will not execute. I also quickly built this same code in the new AB 2020 with the same results.

Ryan Sytsma (In thread: Watcher and sequencing javascript)

This time I got an error that 'adb' is not regocnized as an internal or external command, operable program, or batch file

Ryan Sytsma (In thread: Watcher and sequencing javascript)

using the Run bat is launching the app on my connected tablet but the console window (npm) does not show any console.log out put.

Ryan Sytsma (In thread: Watcher and sequencing javascript)

I followed the directions here ( https://www.getappbuilderhelp.com/help/en-US/apache-cordova.html#batchfiles-integration ) and the app gets launched to my attached Andoid, but the debug console in the AB does not fire up

Ryan Sytsma (In thread: Watcher and sequencing javascript)

The larger issue is that I have about 10 Http Get calls to make do load data into the Sqlite database for offline use. I need to chain those calls together so they run in order of 1:Many relationships. Each Http control is going to have a matching Sqlite insert function similar to the one in this post. So what I was envisioning was some like:

Start Watcher --> Execute Get --> Set Watcher Var to Stop Watcher--> Call JS function from inside Watcher....move on to next Http Get

Ryan Sytsma (In thread: Watcher and sequencing javascript)

If I add this callback to the db.transaction, I dont get the alert or an error:

function(tx, success){
alert("sql init done");
window.App.RootScope.SqlInitDone = "done";
}

this version does not alert either:

function(tx){
alert("sql init done");
window.App.RootScope.SqlInitDone = "done";
}

Ryan Sytsma (In thread: Watcher and sequencing javascript)

I am having problems getting a watcher to work, and I am trying to sequence some javascript to run in the right order.

Fire off watcher start....I get the "watcher start" alert first.

WatcherStart "watcherWaitForSqlInit"
Alert "1" "watcher start"

Run this JS code to create a SQlite database, create a table, and add a record.

StartJS
var db = null;
document.addEventListener('deviceready', function() {
var db = window.sqlitePlugin.openDatabase({ name: 'pts.db', location: 'default' });
db.transaction(function(tx) {
         tx.executeSql("CREATE TABLE IF NOT EXISTS tracking (table, action, record_id)");
         tx.executeSql("INSERT INTO tracking (table, action, record_id) VALUES ('test', 'test', '1')");
         alert("sqlinit created and inserted tracking table");
    },
function (tx, error) {
alert('Open database ERROR at Sqlinit ' + error.message);
});
});
EndJS

Now set the watcher variable value to something...

SetVar "[SqlInitDone]" "done" "String"

I do not get any response from my watcher... None of this watcher code fires off

If "[watcherWaitForSqlInit.OldValue]" "!=" "[watcherWaitForSqlInit.NewValue]"
WatcherStop "watcherWaitForSqlInit"
Alert "1" "sqlinit watcher stopped"

StartJS
var db = null;
document.addEventListener('deviceready', function() {
var db = window.sqlitePlugin.openDatabase({ name: 'pts.db', location: 'default' });

db.transaction(function(tx){

tx.executeSql('SELECT count(*) AS mycount FROM tracking', [], function(rs) {
window.App.RootScope.trackingRowsCount = rs.rows.item(0).mycount;
},
function(tx, error){
alert('Tracking table count error: ' + error.message);
});

}); //db transaction

}); //ready event listener

EndJS
Alert "1" "tracking count = [trackingRowsCount]"
EndIf

Not sure what is going on

Ryan Sytsma (In thread: set Javascript resultset to AB 2019 array)

I have this code to select a record set from a SQLite database using the cordova-sqlite-storage plugin.

db.transaction(function(tx) {
	tx.executeSql("SELECT * FROM users", [], function(tx, resultSet){
    window.App.RootScope.userArray = resultSet;
	});
});

Will AB script recognize that this variable is an array or do I need to append it to an array?

Ryan Sytsma (In thread: Controls Enable and Disable)

Ok, thank you. Disable and Enable functions were not working for me.

Ryan Sytsma (In thread: Controls Enable and Disable)

I am seeing that in all cases, this code will set controls as disabled = true.

This code is in the "ItemClick" event and the "Change" event. The default setting of [selectContract] Disabled = False

If "[typeAheadCustomer.Value]" "==" "No Contract"
SetVar "[selectContract.Disabled]" "True" "String"
Else
SetVar "[selectContract.Disabled]" "False" "String"
EndIf

The control will alsays go from not disabled to disabled, but not toggle depending on the value typed in the typeAheadCustomer control.

Ryan Sytsma (In thread: App Builder 2019)

Got it all up and running again. Thanks

Ryan Sytsma (In thread: App Builder 2019)

David. Still having build issues. I installed NPM, Cordova, JDK, Android Studio with SDK 28 and 29.

Checking Java JDK and Android SDK versions
ANDROID_SDK_ROOT=undefined (recommended setting)
ANDROID_HOME=C:\Program Files (x86)\Android\ (DEPRECATED)
Could not find an installed version of Gradle either in Android Studio,
or on your system to install the gradle wrapper. Please include gradle
in your path, or install Android Studio
Press any key to continue . . .

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.