Posts by DecSoft

Hello Samuel,

In fact we play with global variables anyway: the problem here is the order in which the variable "Retour" are set. Since the user functions are compiled after the app views/controls, when App Builder translate the "split" action to the appropiate Javascript code, they don't know nothing about the "Retour" variable and the final Javascript code do not produce our expected results.

By set the "Retour" variable before call the user function (no matter if we set the variable in the "Ready" app event, or the "Show" app view event, or just before call the user function) when App Builder translate the "split" action can view that the "Retour" variable exists, and then the final Javascript code produced our expected results. We can view the differences in the below codes:

This is the final "split" function Javascript code if we do not set the "Retour" variable before call the user function:

This is the final "split" function Javascript code if we set the "Retour" variable before call the user function:

We can see that, because App Builder do not recognize the "Retour" variable when translate the "split" action, they take the variable as an string, and this do not produce our desired results. On the contrary, the second code show to us how we deal directly with the variable "Retour" as a variable, not an string, and in this case the "split" function produces the expected results.

Hello Samuel,

Thanks very much for the sample. Certainly the problem is related with how App Builder compile the app code. The program compile first the app views/controls, then the app events, and then the user functions. Since the app views/controls are compiled before the user functions, then the variable "Retour" do not exists for the app views/controls and this cause the problem in our specific case.

What we can do is to set the "Retour" variable before call the user function which use it:

Try it and post here whatever question Samuel.

Hello Samuel,

Trying to reproduce the error I can't do it, because I do not understand very well what you mean when talking about "App Builder function which return an string", then I only can try the "button click way", and this apparently works like expected (see the code below). So please Samuel, if you can provide me with a little app sample I really appreciate it and I will investigate the problem.

Hello,

In fact I am the first interested in a possible combination of App Builder and HTML Compiler, and it's something I plain when start to develop App Builder, however, I asume that this combination is not possible since the refered issues. However I still perservere in App Builder development, and also HTML compiler, because both programs meet their promises, even when they can't work together.

Maybe the most problematic issues exists in the HTML Compiler part, because the use of the "special protocol". But HTML Compiler cannot renounce this way since in fact they are what allow us to meet the HTML Compiler promise: never extract files to the user computer. This is because I never announce HTML Compiler as a "website compiler" or something else.

What HTML Compiler expect is HTML apps writen mostly from the scratch and which take in count the possible limitation of the HTML Compiler environment. Doing this we can be sure our HTML files never be extracted to the user computer, even when we can do this optionally. The conclusion is I prefer to say "this is not possible" than "maybe" or "yes, but not enterelly".

Hello Samuel,

The problem is that the WebBrowser control (and also Internet Explorer), in which HTML Compiler is based, do not support "ajax" for local files in the same way than Mozilla Firefox or Google Chrome does. Also some other features like local storage cannot work for local files in Internet Explorer. For this reasons App Builder debugger is based in an internal HTTP server as you can see.

On the other hand, HTML Compiler relies in the WebBrowser control and certain proprietary Microsoft Internet Explorer protocol, which in fact allow us to do what we wanted with HTML Compiler: never extract any file to the user computer, if we do not wanted this. So with minor or no changes App Builder apps cannot works in HTML Compiler, which can be something good to me too.

We can try using AngularJS script tags instead of individual app HTML files per every app views. This is not the recomended way for more or less larger apps, however, maybe we can do it in order to get ready for HTML Compiler. But the problems just starts here, since other features like local storage cannot works like we expected.

I prepare for you the Calculator sample using script tags instead HTML files per the app views. Download this sample from here. As you can see they can work as an HTML Compiler project, however, some things do not works properly like the themes select control. Most of them are related with the refered local storage problem.

The other problem I can note is that the icons doesn't works too. The problem this time is that HTML Compiler cannot deal with the font files which include the icons. This time the limitation is in HTML Compiler, but we can expect some limitations like that in a program like this, at least all programs which use the same Microsoft Internet Explorer protocol used by HTML Compiler. The refered protocol support almost everything than local files support, but not everything.

Then the conclusion is that maybe we can adapt some specific apps to be used in HTML Compiler, but, currently is not something available for every apps and definetively is not an easy thing to do: I mean we cannot do it using a few clicks.

Hello Walter,

In fact they are a mistake of mine. Yes I try to set the backdround in other than the current view, which is something that do not work, and have some sense. But by mistake I leave the "NewView2" and the action in the button.

Hello Walter,

Yes; is possible to use the SetStyle action just like you suggest.

Just assert you use an URL or a previously added app image file.

Take a look at this app sample.

Hello Nelson,

The problem is that access SQLite from the HTML5 API appear to be droped in the future and is currently not supported by IE, for example. Currently you can use plain text, JSON files and local storage in order to store and retrieve app data. And also can use HTTP calls in order to update or add new information from the app.

How the HTTP calls are made depends completely on the app, because many different servers/languages can be used for this purpose. Probably you no need to send SQL queries along internet, because you can prepare end points for your app calls in order to retrieve or set database information.

Unfortunatelly we can wait an entire life for view a SQLite support in web browsers Nelson...

Hello Walter,

In a Multiselect control we do not have an "ItemIndex" variable like in the Select control. What we have is an "Items" variable and an "SelItems" variable. Since "SelItems" variable contains the selected items, if a user choose one item, then the "SelItems" variable contains one element with the selected item value.

From that value we can use the ArrayIndexOf action over the select items array in order to get the selected item index. Take a look at the bellow code, which you can put in a "Change" event of a Multiselect control (which contains a few items):

Note that in the above code we also check the user select more than one item. If so, we take the first of the selected items and omit all others. If you have any other doubt do not hesitate to post here Walter.

Hello Walter,

Testing with the SamplePost app sample I can write something like this:

And works like expected, in the sense that I can get the into the "sql" POST variable the text "SELECT * FROM test";.

Maybe the problem is how you try to use the "sql" POST variable in PHP. First of all assert you receive such variable by simple "echo" it. Secondly assert you can use the content of such variable in the context you wanted to use. For example, maybe the quotes of the text cause the problem. Try something like this instead:

Hello Walter,

Connect PHP and JS sound a little confuse, since PHP is a server language and JS is a client language, then by definition their have different scenarios. Depend on what you wanted the answer can vary. Make HTTP request to a server in order to be processed by PHP is very simple by using actions like SimpleGet, SimplePost or the HttpClient control.

What data we can receive from a server and how to deal with it depend on every app. Take a look at the Report app sample, for example. This sample show us how we can parse JSON data into an HTML table. The JSON of the app sample is loaded directly from a file (included with the sample) but the sample also incorporates a "data.php" file, which show us how we can create (in a server) the JSON to be received and processed by the app.

Hello Walter,

When we add controls inside a container control in designtime these controls are also inside the container in runtime too. For example, if you wanted to show or hide the container and all the controls inside you can use the Show, Hide or Toggle actions indicating the container name or ID. About the resolution you can try with some app events like Resize and Orientation, and count with some app global variables like "App.Orientation", "App.InnerWidth", "App.OuterWidth", etc.

Hello Samuel,

Thanks for your comments. Glad to know you are updated with the Typeahead input control. About the Tools and Actions panels, you know the first App Builder releases do not allow us to filter them. Filter is something important due to the number of Tools and Actions. I think the best way to find for Tools and Actions is to use the filter feature.

On the other hand you are right: the Tools and Actions panels do not appear sorted alfabetically and I also think this can be useful. I need to think a little about but I promise that, at least I want to try with a possible solution.

Hello Walter,

That probably depends on the app, however, a general advise can be we never, never trust in the user input, then validate such input in the app (before send to the server) and always in the server too, before put the input in a database, for example. If you can explain a little your preventions maybe I can help you in some manner.

Hello Walter,

A container control basically allow us to put inside other controls, then, for example, we can hide/show the container and then hide and show all the controls inside the container. What kind of sample you wanted Walter?