Hi PPetree, I have tried different positions and the deviceready etc and without getting the sql to work.
I need to work with your config for everything, a question …
When you use your config, don’t you need to include the following ?:
Because that is what the sql does not allow to use with:
“cordova-sqlite-evcore-extbuild-free”
Thanks for the reply and support.
I’m using
<plugin name="cordova-sqlite-storage" spec="5.0.0" />
and @nate is correct, you have to initialize the database AFTER the deviceready event.
How are you calling the plugin?
switch(device.platform)
{
case "ios":
case "iOS":
params = {name: 'myDatabase', iosDatabaseLocation: 'default'};
break;
case "android":
case "Android":
params = {name: 'myDatabase', location: 'default'};
break;
}
myDB = window.sqlitePlugin.openDatabase(params, function() {
console.log("the database is open, now create the table");
});
Thanks for answering. I’m going to try, I’ll tell you if it works.
I have been making variants of what I indicate below, but it did not work.
Sub Main()
'----------------------------------------------------------------------
SeriesName="Calculadora"
proyectob=SeriesName
'----------------------------------------------------------------------
If typeof(cordova)<>"undefined" Then
'----------------------------------------------------------------------
'MsgBox "Runing en phonegap "&typeof(cordova)
'----------------------------------------------------------------------
Button7.style.backgroundColor=RGB(255,0,0)
Button8.style.backgroundColor=RGB(0,255,0)
'----------------------------------------------------------------------
DB = null
document.addEventListener("deviceready", ArrancaSql, True)
'----------------------------------------------------------------------
Else
'----------------------------------------------------------------------
'MsgBox "Runing inbrowser"&typeof(cordova)
'----------------------------------------------------------------------
'Create database if it does not exist
DB = SqlOpenDatabase("calculadora.db","1.0","Datos de Calculadora")
sqlList=[]
TextoCarga="CREATE TABLE calculadoraData('ordennoP','proyecto','detalle','serieA','serieB','serieC','serieD','serieE','serieF',"
TextoCarga=TextoCarga&"'serieG','serieH','serieI','serieJ','serieK','serieL','serieM','serieN','serieO','serieP','serieQ','serieR',"
TextoCarga=TextoCarga&"'serieS','serieT','serieU','serieV','serieW','serieX','serieY','serieZ','serieAA','serieAB','serieAC','serieAD',"
TextoCarga=TextoCarga&"'serieAE','serieAF','serieAG','serieAH','serieAI','serieAJ','serieAK','serieAL','serieAM','serieAN','serieAO',"
TextoCarga=TextoCarga&"'serieAP','serieAQ','serieAR','serieAS','serieAT','serieAU','serieAV','serieAW','serieAX','serieAY','serieAZ', "
TextoCarga=TextoCarga&"'serieBA','serieBB','serieBC','serieBD',"
TextoCarga=TextoCarga&"'serieBE','serieBF','serieBG','serieBH','serieBI','serieBJ','serieBK','serieBL','serieBM','serieBN','serieBO',"
TextoCarga=TextoCarga&"'serieBP','serieBQ','serieBR','serieBS','serieBT','serieBU','serieBV','serieBW','serieBX','serieBY','serieBZ', "
TextoCarga=TextoCarga&"'serieCA','serieCB','serieCC','serieCD','serieCE','serieCF',"
TextoCarga=TextoCarga&"'serieCG','serieCH','serieCI','serieCJ','serieCK','serieCL',"
TextoCarga=TextoCarga&"'serieCM','serieCN','serieCO','serieCP','serieCQ','serieCR','serieCS','serieCT','serieCU','serieCV','serieCW','serieCX',"
TextoCarga=TextoCarga&"'serieFiltro','serieModo', "
TextoCarga=TextoCarga&"PRIMARY KEY ('ordennoP') );"
sqlList[0]=[TextoCarga, success, fail]
Sql(DB, sqlList)
'------------------------------------------------------------------
Button1.style.backgroundColor=RGB(255,0,0)
Button2.style.backgroundColor=RGB(255,0,0)
'------------------------------------------------------------------
Button7.style.backgroundColor=RGB(0,255,0)
Button8.style.backgroundColor=RGB(255,0,0)
'------------------------------------------------------------------
Button7.value=typeof(cordova)
'------------------------------------------------------------------
End If
End Sub
'=================================================================
Function ArrancaSql()
JavaScript
DB = window.sqlitePlugin.openDatabase({
name: 'calculadora.db',
location: 'default',
})
End JavaScript
DB = SqlOpenDatabase("calculadora.db","1.0","Datos de Calculadora")
sqlList=[]
TextoCarga="CREATE TABLE calculadoraData('ordennoP','proyecto','detalle','serieA','serieB','serieC','serieD','serieE','serieF',"
TextoCarga=TextoCarga&"'serieG','serieH','serieI','serieJ','serieK','serieL','serieM','serieN','serieO','serieP','serieQ','serieR',"
TextoCarga=TextoCarga&"'serieS','serieT','serieU','serieV','serieW','serieX','serieY','serieZ','serieAA','serieAB','serieAC','serieAD',"
TextoCarga=TextoCarga&"'serieAE','serieAF','serieAG','serieAH','serieAI','serieAJ','serieAK','serieAL','serieAM','serieAN','serieAO',"
TextoCarga=TextoCarga&"'serieAP','serieAQ','serieAR','serieAS','serieAT','serieAU','serieAV','serieAW','serieAX','serieAY','serieAZ', "
TextoCarga=TextoCarga&"'serieBA','serieBB','serieBC','serieBD',"
TextoCarga=TextoCarga&"'serieBE','serieBF','serieBG','serieBH','serieBI','serieBJ','serieBK','serieBL','serieBM','serieBN','serieBO',"
TextoCarga=TextoCarga&"'serieBP','serieBQ','serieBR','serieBS','serieBT','serieBU','serieBV','serieBW','serieBX','serieBY','serieBZ', "
TextoCarga=TextoCarga&"'serieCA','serieCB','serieCC','serieCD','serieCE','serieCF',"
TextoCarga=TextoCarga&"'serieCG','serieCH','serieCI','serieCJ','serieCK','serieCL',"
TextoCarga=TextoCarga&"'serieCM','serieCN','serieCO','serieCP','serieCQ','serieCR','serieCS','serieCT','serieCU','serieCV','serieCW','serieCX',"
TextoCarga=TextoCarga&"'serieFiltro','serieModo', "
TextoCarga=TextoCarga&"PRIMARY KEY ('ordennoP') );"
sqlList[0]=[TextoCarga, success, fail]
Sql(DB, sqlList)
'------------------------------------------------------------------
Button1.style.backgroundColor=RGB(255,0,0)
Button2.style.backgroundColor=RGB(255,0,0)
'------------------------------------------------------------------
Button7.style.backgroundColor=RGB(0,255,0)
Button8.style.backgroundColor=RGB(255,0,0)
'------------------------------------------------------------------
End Function
'====================================================================
Hi PPetree, thanks again for the instructions but I tell you that I don’t know how to make it compatible with Basic. When I tried, everything stopped at the little application I made as a test.
Leugo included all your ‘config’ and it worked very well but when I included '… wkwebview-engine … "I stop doing it.
Apparently I will have to wait for the compatible one because my applications have sql but with:
“<plugin name =” cordova-sqlite-evcore-extbuild-free “source =” npm “/>” or to make an example to make the versions compatible.
Thanks again for the support and if someone has solved this problem before, please indicate how to do it, if you can in Basic.
Regards,
If you surround the code with JavaScript/End JavaScript you can put JS code in the middle of your BASIC:
a = 1
JavaScript
switch(device.platform)
{
case "ios":
case "iOS":
params = {name: 'myDatabase', iosDatabaseLocation: 'default'};
break;
case "android":
case "Android":
params = {name: 'myDatabase', location: 'default'};
break;
}
myDB = window.sqlitePlugin.openDatabase(params, function() {
console.log("the database is open, now create the table");
});
End JavaScript
b = 2
This absolutely works so this isn’t a problem with wkwebview.
First, make sure you have your config.xml set correctly.
<platform name="ios"
<feature name="CDVWKWebViewEngine">
<param name="ios-package" value="CDVWKWebViewEngine" />
</feature>
<preference name="CordovaWebViewEngine" value="CDVWKWebViewEngine" />
</platform>
<plugin name="cordova-plugin-wkwebview-engine" spec="1.2.1" />
<plugin name="cordova-plugin-wkwebview-file-xhr" spec="2.1.4" />
<plugin name="cordova-sqlite-storage" spec="5.0.0" />
Next, you don’t have to check if cordova is “undefined”
'---------- this just not needed and unreliable ----------------
If typeof(cordova)<>"undefined" Then
In your code, as early you can set your
document.addEventListener("deviceready", ArrancaSql, True)
Next (and you’ll have to ask @ghenne about this) I would question the scope of your DB = null inside of that if conditional. If memory serves me correctly (its been decades since I last used basic), that needs to be outside of the IF or it will not retain its value.
Next, in your opendatabase parameters, you use location: ‘default’ and this is only valid on android and will not work on iOS. If you’re testing on Android that’s fine but beware.
Next, reformat your deviceready event handler. Don’t call your ArrancaSql directly, instead, create a higher level function and call ArrancaSql from within that upper level function that way you can make sure your deviceready is getting fired.
Lastly, check your console.log and tell us what, if any, errors you’re getting.
Setting variables inside a JavaScript block is fine. It uses the same variable space.
All that happens is the Translator turns off while processing the JavaScript block.
In his code the DB= is inside of a basic conditional… or did I miss something?
@PPetree, do you mean this?
a = 100
JavaScript
if (a === 100) {
b = 200;
}
a = 50;
End JavaScript
Print a,b
Output is 50 200.
First of all, thanks. I’m already testing it. I will tell you how it went.
Regards,
@ghenne No, that’s inside the javascript tags you posted.
In his code, inside the first IF there’s a line that says DB = null right above the addEventListener.
If you have DB = null but it is to recognize when working outside of my browser. In the browser if it works for me.
I’m trying to put it together with what I’ve been told. Now I have a “Start0” function before “Start1” … where Start0 I understand would be the higher level that was indicated to me.
It still doesn’t work for me but I’m going here …
'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Dim BIni(102)
Dim DB
Dim sqlList
Dim calcdata=[[0]] 'The current calcdata in a 2D array
Dim nFilasBD
Dim ordennob
Dim proyectob
Dim detalleb
Dim SeriesName
Dim LinesImp
Dim AccionBD
Dim nFilasBD
Dim calcdata
Dim TextoCarga
Dim params
'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
'===================================================
Sub Main()
'----------------------------------------------------------------------
SeriesName="Calculadora"
proyectob=SeriesName
'----------------------------------------------------------------------
If typeof(cordova)<>"undefined" Then
'----------------------------------------------------------------------
'MsgBox "Runing en phonegap "&typeof(cordova)
'----------------------------------------------------------------------
Button7.style.backgroundColor=RGB(255,0,0)
Button8.style.backgroundColor=RGB(0,255,0)
'----------------------------------------------------------------------
document.addEventListener("deviceready", ArrancaSql0, True)
'----------------------------------------------------------------------
Else
'----------------------------------------------------------------------
'MsgBox "Runing inbrowser"&typeof(cordova)
'----------------------------------------------------------------------
'Create database if it does not exist
DB = SqlOpenDatabase("calculadora.db","1.0","Datos de Calculadora")
sqlList=[]
TextoCarga="CREATE TABLE calculadoraData('ordennoP','proyecto','detalle','serieA','serieB','serieC','serieD','serieE','serieF',"
TextoCarga=TextoCarga&"'serieG','serieH','serieI','serieJ','serieK','serieL','serieM','serieN','serieO','serieP','serieQ','serieR',"
TextoCarga=TextoCarga&"'serieS','serieT','serieU','serieV','serieW','serieX','serieY','serieZ','serieAA','serieAB','serieAC','serieAD',"
TextoCarga=TextoCarga&"'serieAE','serieAF','serieAG','serieAH','serieAI','serieAJ','serieAK','serieAL','serieAM','serieAN','serieAO',"
TextoCarga=TextoCarga&"'serieAP','serieAQ','serieAR','serieAS','serieAT','serieAU','serieAV','serieAW','serieAX','serieAY','serieAZ', "
TextoCarga=TextoCarga&"'serieBA','serieBB','serieBC','serieBD',"
TextoCarga=TextoCarga&"'serieBE','serieBF','serieBG','serieBH','serieBI','serieBJ','serieBK','serieBL','serieBM','serieBN','serieBO',"
TextoCarga=TextoCarga&"'serieBP','serieBQ','serieBR','serieBS','serieBT','serieBU','serieBV','serieBW','serieBX','serieBY','serieBZ', "
TextoCarga=TextoCarga&"'serieCA','serieCB','serieCC','serieCD','serieCE','serieCF',"
TextoCarga=TextoCarga&"'serieCG','serieCH','serieCI','serieCJ','serieCK','serieCL',"
TextoCarga=TextoCarga&"'serieCM','serieCN','serieCO','serieCP','serieCQ','serieCR','serieCS','serieCT','serieCU','serieCV','serieCW','serieCX',"
TextoCarga=TextoCarga&"'serieFiltro','serieModo', "
TextoCarga=TextoCarga&"PRIMARY KEY ('ordennoP') );"
sqlList[0]=[TextoCarga, success, fail]
Sql(DB, sqlList)
'------------------------------------------------------------------
Button1.style.backgroundColor=RGB(255,0,0)
Button2.style.backgroundColor=RGB(255,0,0)
'------------------------------------------------------------------
Button7.style.backgroundColor=RGB(0,255,0)
Button8.style.backgroundColor=RGB(255,0,0)
'------------------------------------------------------------------
Button7.value=typeof(cordova)
'------------------------------------------------------------------
End If
End Sub
'====================================================================
Function ArrancaSql0()
'document.addEventListener("deviceready", ArrancaSql1, True)
Print "llego a ArrancaSql0()"
JavaScript
switch(device.platform)
{
case "ios":
case "iOS":
params = {name: 'calculadora', iosDatabaseLocation: 'default'};
break;
case "android":
case "Android":
params = {name: 'calculadora', location: 'default'};
break;
}
myDB = window.sqlitePlugin.openDatabase(params, function() {
ArrancaSql1();
});
End JavaScript
End Function
'====================================================================
Function ArrancaSql1()
Print "llego a ArrancaSql1()"
DB = SqlOpenDatabase("calculadora.db","1.0","Datos de Calculadora")
sqlList=[]
TextoCarga="CREATE TABLE calculadoraData('ordennoP','proyecto','detalle','serieA','serieB','serieC','serieD','serieE','serieF',"
TextoCarga=TextoCarga&"'serieG','serieH','serieI','serieJ','serieK','serieL','serieM','serieN','serieO','serieP','serieQ','serieR',"
TextoCarga=TextoCarga&"'serieS','serieT','serieU','serieV','serieW','serieX','serieY','serieZ','serieAA','serieAB','serieAC','serieAD',"
TextoCarga=TextoCarga&"'serieAE','serieAF','serieAG','serieAH','serieAI','serieAJ','serieAK','serieAL','serieAM','serieAN','serieAO',"
TextoCarga=TextoCarga&"'serieAP','serieAQ','serieAR','serieAS','serieAT','serieAU','serieAV','serieAW','serieAX','serieAY','serieAZ', "
TextoCarga=TextoCarga&"'serieBA','serieBB','serieBC','serieBD',"
TextoCarga=TextoCarga&"'serieBE','serieBF','serieBG','serieBH','serieBI','serieBJ','serieBK','serieBL','serieBM','serieBN','serieBO',"
TextoCarga=TextoCarga&"'serieBP','serieBQ','serieBR','serieBS','serieBT','serieBU','serieBV','serieBW','serieBX','serieBY','serieBZ', "
TextoCarga=TextoCarga&"'serieCA','serieCB','serieCC','serieCD','serieCE','serieCF',"
TextoCarga=TextoCarga&"'serieCG','serieCH','serieCI','serieCJ','serieCK','serieCL',"
TextoCarga=TextoCarga&"'serieCM','serieCN','serieCO','serieCP','serieCQ','serieCR','serieCS','serieCT','serieCU','serieCV','serieCW','serieCX',"
TextoCarga=TextoCarga&"'serieFiltro','serieModo', "
TextoCarga=TextoCarga&"PRIMARY KEY ('ordennoP') );"
sqlList[0]=[TextoCarga, success, fail]
Sql(DB, sqlList)
'------------------------------------------------------------------
Button1.style.backgroundColor=RGB(255,0,0)
Button2.style.backgroundColor=RGB(255,0,0)
'------------------------------------------------------------------
Button7.style.backgroundColor=RGB(0,255,0)
Button8.style.backgroundColor=RGB(255,0,0)
'------------------------------------------------------------------
End Function
'====================================================================
'********** Movimientos en la BD **********
'====================================================================
Sub success()
Print "Exito=Ok"
Button1.style.backgroundColor=RGB(0,160,0)
End Sub
'------------------------------------------------------------------------------------------
Sub fail()
Print "Problemas pero llego=Error"
Button2.style.backgroundColor=RGB(0,160,0)
End Sub
'====================================================================
'====================================================================
What do you mean “doesn’t work”? What errors are you getting?
The application works with sql always, except the case where I include the following: wkwebview
In this case, the error is that it is indicated:
SQLite is not supported
This happens with:
“cordova-sqlite-storage” or “cordova-sqlite-evcore-extbuild-free”
Now, to use the instructions that you give me, I need to change it from Javascript to Basic and there I have an additional problem. The conversion.
I am seeing the problem with iOS, with Android nor have I touched it.
Dear Sirs:
It worked!!!
Thank you all!!!
My special thanks to PPetree.
worked effectively with plugin name = “cordova-sqlite-storage” spec = “5.0.0”
and some changes that I tried with what you suggested to me and others that I read.
Below I show you what worked for me in case it works for someone.
'===================================================
Sub Main()
'----------------------------------------------------------------------
SeriesName="Calculadora"
proyectob=SeriesName
'----------------------------------------------------------------------
If typeof(cordova)<>"undefined" Then
'----------------------------------------------------------------------
'MsgBox "Runing en phonegap "&typeof(cordova)
'----------------------------------------------------------------------
Button7.style.backgroundColor=RGB(255,0,0)
Button8.style.backgroundColor=RGB(0,255,0)
'----------------------------------------------------------------------
Else
'----------------------------------------------------------------------
'MsgBox "Runing inbrowser"&typeof(cordova)
'----------------------------------------------------------------------
'Create database if it does not exist
DB = SqlOpenDatabase("calculadora.db","1.0","Datos de Calculadora")
sqlList=[]
TextoCarga="CREATE TABLE calculadoraData('ordennoP','proyecto','detalle','serieA','serieB','serieC','serieD','serieE','serieF',"
TextoCarga=TextoCarga&"'serieG','serieH','serieI','serieJ','serieK','serieL','serieM','serieN','serieO','serieP','serieQ','serieR',"
TextoCarga=TextoCarga&"'serieS','serieT','serieU','serieV','serieW','serieX','serieY','serieZ','serieAA','serieAB','serieAC','serieAD',"
TextoCarga=TextoCarga&"'serieAE','serieAF','serieAG','serieAH','serieAI','serieAJ','serieAK','serieAL','serieAM','serieAN','serieAO',"
TextoCarga=TextoCarga&"'serieAP','serieAQ','serieAR','serieAS','serieAT','serieAU','serieAV','serieAW','serieAX','serieAY','serieAZ', "
TextoCarga=TextoCarga&"'serieBA','serieBB','serieBC','serieBD',"
TextoCarga=TextoCarga&"'serieBE','serieBF','serieBG','serieBH','serieBI','serieBJ','serieBK','serieBL','serieBM','serieBN','serieBO',"
TextoCarga=TextoCarga&"'serieBP','serieBQ','serieBR','serieBS','serieBT','serieBU','serieBV','serieBW','serieBX','serieBY','serieBZ', "
TextoCarga=TextoCarga&"'serieCA','serieCB','serieCC','serieCD','serieCE','serieCF',"
TextoCarga=TextoCarga&"'serieCG','serieCH','serieCI','serieCJ','serieCK','serieCL',"
TextoCarga=TextoCarga&"'serieCM','serieCN','serieCO','serieCP','serieCQ','serieCR','serieCS','serieCT','serieCU','serieCV','serieCW','serieCX',"
TextoCarga=TextoCarga&"'serieFiltro','serieModo', "
TextoCarga=TextoCarga&"PRIMARY KEY ('ordennoP') );"
sqlList[0]=[TextoCarga, success, fail]
Sql(DB, sqlList)
'------------------------------------------------------------------
Button1.style.backgroundColor=RGB(255,0,0)
Button2.style.backgroundColor=RGB(255,0,0)
'------------------------------------------------------------------
Button7.style.backgroundColor=RGB(0,255,0)
Button8.style.backgroundColor=RGB(255,0,0)
'------------------------------------------------------------------
Button7.value=typeof(cordova)
'------------------------------------------------------------------
End If
End Sub
'====================================================================
'====================================================================
'====================================================================
JavaScript
// Wait For Cordova To load
document.addEventListener("deviceready", onDeviceReady, False);
End JavaScript
'====================================================================
Function onDeviceReady()
Print "onDeviceReady() "
ArrancaSql1()
End Function
'====================================================================
Function ArrancaSql1()
Print "llego a ArrancaSql1()"
DB = window.sqlitePlugin.openDatabase({name: "calculadora.db", location: 1})
sqlList=[]
TextoCarga="CREATE TABLE calculadoraData('ordennoP','proyecto','detalle','serieA','serieB','serieC','serieD','serieE','serieF',"
TextoCarga=TextoCarga&"'serieG','serieH','serieI','serieJ','serieK','serieL','serieM','serieN','serieO','serieP','serieQ','serieR',"
TextoCarga=TextoCarga&"'serieS','serieT','serieU','serieV','serieW','serieX','serieY','serieZ','serieAA','serieAB','serieAC','serieAD',"
TextoCarga=TextoCarga&"'serieAE','serieAF','serieAG','serieAH','serieAI','serieAJ','serieAK','serieAL','serieAM','serieAN','serieAO',"
TextoCarga=TextoCarga&"'serieAP','serieAQ','serieAR','serieAS','serieAT','serieAU','serieAV','serieAW','serieAX','serieAY','serieAZ', "
TextoCarga=TextoCarga&"'serieBA','serieBB','serieBC','serieBD',"
TextoCarga=TextoCarga&"'serieBE','serieBF','serieBG','serieBH','serieBI','serieBJ','serieBK','serieBL','serieBM','serieBN','serieBO',"
TextoCarga=TextoCarga&"'serieBP','serieBQ','serieBR','serieBS','serieBT','serieBU','serieBV','serieBW','serieBX','serieBY','serieBZ', "
TextoCarga=TextoCarga&"'serieCA','serieCB','serieCC','serieCD','serieCE','serieCF',"
TextoCarga=TextoCarga&"'serieCG','serieCH','serieCI','serieCJ','serieCK','serieCL',"
TextoCarga=TextoCarga&"'serieCM','serieCN','serieCO','serieCP','serieCQ','serieCR','serieCS','serieCT','serieCU','serieCV','serieCW','serieCX',"
TextoCarga=TextoCarga&"'serieFiltro','serieModo', "
TextoCarga=TextoCarga&"PRIMARY KEY ('ordennoP') );"
sqlList[0]=[TextoCarga, success, fail]
Sql(DB, sqlList)
'------------------------------------------------------------------
Button1.style.backgroundColor=RGB(255,0,0)
Button2.style.backgroundColor=RGB(255,0,0)
'------------------------------------------------------------------
Button7.style.backgroundColor=RGB(255,0,0)
Button8.style.backgroundColor=RGB(0,255,0)
'------------------------------------------------------------------
End Function
'====================================================================
'********** Movimientos en la BD **********
'====================================================================
Sub success()
Print "Exito=Ok"
Button1.style.backgroundColor=RGB(0,160,0)
End Sub
'------------------------------------------------------------------------------------------
Sub fail()
Print "Problemas pero llego=Error"
Button2.style.backgroundColor=RGB(0,160,0)
End Sub
'====================================================================
Dear sirs, as I already indicated, I was able to make Sql work. however, it cannot read the DB that was created before the switch to WkWebview.
I have already tried on my part, everything you can understand could be and I have not managed to read the Previous DB. If someone has previously had this problem and could tell me how to do it (Basic), will I be very grateful?
Thanks in advance for the support.
Regards