Digital Workshop

Good day,

This script works well in desktop but not in android.
I don't get data from the database.
What is wrong?

function querySearch()
{

TextDataHoje.SetSelection(0,-1)
search = TextDateToday.GetSelectionText()
var url = "http://server.com/scripts/app.php"
var obj =new Object()
obj.tabela = table
obj.pesq = search
var post = InternetPostData(url,obj,true)

TEXT.SetSelection(-1,0);
TEXT.ReplaceSelection(post.print_DATA);
....
}


<?php

$DBhost = "localhost";
$DBuser = "username";
$DBpass = "userpassword";
$DBName = "databasename";

$tabela = $_POST["tabela"];
$pesq = $_POST["pesq"];

$connect = mysql_connect($DBhost,$DBuser,$DBpass);
$db = mysql_select_db($DBName,$connect);
$query = "SELECT * FROM $tabela WHERE data ='".$pesq."'";
$result = mysql_query($query, $connect);
mysql_data_seek($result, $reg);
$row = mysql_fetch_array($result );

$data = "&print_ID=".$row['id']."&print_DATA=".$row['data'],...;
echo $data;
?>

Have you enabled Internet Access on the options tab when publishing?

</mack>

Good day mackavi,
I am Not able to create the app because I'm with this error "Error launching apktool"

You do have the SE SDK installed?

</mack>

yes i have.

C:\Program Files (x86)\Java\jdk1.8.0_152
C:\Program Files (x86)\Android\android-sdk

Unfortunately, as I use Opus and XDK for Android applications, with the exception of knowing that it works with the SDK which was already configured for other software I use, I don't have any need for the in-built solution and no experience of anything but basic problems.

I can tell you that you're using the 32 bit version and my system and Opus are using the 64bit. Maybe that's the problem.

</mack>

do you convert the project to HTML5 and with the XDK for Android to create a app?

There's no converting needed. Both Opus and XDK simply wrap HTML5 code for Android (or other devices).

You can just build in Opus HTML5 you don't need to select the Android option. The only requirement is that the main file is called index.html.

Opus Android is much, much easier than XDK to use though.

</mack>

I've managed it to work.

thank you mac

but this don' t work in html5 why?

function data()
{

switch(SYSTEM_TIME_MONTH)
{

case "Jan":
currMonth ="Janeiro";
break;

case "Feb":
currMonth ="Feveiro";
break;

case "Mar":
currMonth ="Março";
break;

case "Apr":
currMonth ="Abril";
break;

case "Jun":
currMonth ="Junho";
break;

case "Jul":
currMonth ="Julho";
break;

case "Aug":
currMonth ="Agosto";
break;

case "Sep":
currMonth ="Setembro";
break;

case "Oct":
currMonth ="Outubro";
break;

case "Nov":
currMonth ="Movembro";
break;

case "Dec":
currMonth ="Dezembro";
break;

default:
break;

}

DATA_HOJE = null
DATA_HOJE = SYSTEM_TIME_DATE+" "+currMonth+" "+SYSTEM_TIME_YEAR
TextDataHoje.ReplaceSelection(DATA_HOJE)
}

When you say doesn't work - do you get an undefined message on screen?

</mack>

does not appear any message

From just the code, I don't see what would cause no message to appear. It would be 'undefined' if the variables hadn't updated which will occur if called too soon or not triggered, such as not having any variable on screen to update.

Does it work in Opus preview?

Also, why are you replacing text - rather than simply displaying the DATA_HOJE variable on the page?

</mack>

works well

I can send you a link to dropbox.

Working switch-case. Download from our website using code: switchcase@digitalgrapevine.info

</mack>

did you see the project that i have sent, "EDAViewer"?