Hi David,
I am trying to read a text file (a .csv infact) into the an App builder app, conduct a decryption and write the back where it was.
To do so, I am studying the "files" sample, in its description it says it needs to built by Cordova to work. So I built it for browser. However I have troubles getting it to work and my searches does not help much!
So Cordova just says that whitelist, file and dialogs plug ins, are installed and saved to config, I get no success message but no errors either, in the path folder I get browser.json, config.xml, www, platform_www and cordova folders and no html or executable files. index.html in the www folder also does not run.
Am I missing something or it is just my ignorance around the building a browser app by Cordova?
Thanks in advance for your help.
Hi David,
I have an AB function, I want to use the argument to give a part of the controller's name , but I have an error with argument, how can i use?
For example(myfunction):
Enable "Button[arg]"
Call (AB):
myfunction "6"
Tanks
Hi David,
I have an AB function, between my codes I want to use the Disable function with argument, but I have an Error with argument!what is the problem?
For example:
Thanks
but If the function has arguments, how to give it an argument?
Tanks
Hi David, I have a function in AB, now i need to use that in JS,
how can call a AB function in JS?
Thanks
Hi David,
At properties/font family there are a few font options available like "Arial" and "Times New Roman". I suspect in inline css we also can use these fonts for the texts. What if we need to use a fancy font like "Scriptina" for instance. How can we add it to appbuilder and use it in the applications?
Thanks
Hi David,
I was wondering how can we add fonts to Appbuilder font list?
Thanks
Hi David, it is working now, very helpful as always. THANK YOU
Hi David,
I know that when a variable like "test" is defined in the AB we can refer to it in JS as "window.App.RootScope.test" . But when we have a function and function has an argument named as "arg1" if within the function we use JS, "window.App.RootScope.arg1" does not get the argument. I was wondering how can we pull the arguments in JS? thanks
Thanks a lot David for always going the extra mile, I did not expect you to look into that because it is totally irrelevant to AB and the APIs I got from it. But any how to clear things up. I am running a query like below:
Because both sides of JOIN are running the same query (SELECT * FROM T1) it will be more efficient if we can buffer it somewhere first time it is run and then reuse it the second time. This in a simplified example and when the reused query is something with a few joins and subqueries and data has millions of records it will make a measurable difference. In SQLSERVER and ORACLE this issue can be taking care of by TEMPORARY tables and/or WITH but MySQL temporary tables does not help with this. WITH is available in MySQL 8 apparently but my server's SQL version is 5.6 and does not support WITH so I am stuck doing my best to replicate these using views, memory engines and technically anything that has the ability to speed up my query in a similar fashion. Don't worry about it though, I will find a way for it ;)
Hi David,
During the debugging I figured that
Was infact working correctly, and my view was created, the reason I get the errors is that I am trying to replicate "WITH" in MySQL and still have no luck. Thanks a million
Hi David,
I have got stock in optimising my query somewhere I think you could advise.
I am trying to run the below query on the API you have provided for AB Database example:
I use Database::getResults in the API to run the SELECT part that works fine, but I had not been able to run the CREATE VIEW as of yet. I tried
and a few other pdo functions to execute the CREATE VIEW but had not luck. I appreciate if you advise.
Regards,
Thanks a lot for your help David. Much appreciated, I will take your recommendation and stick to processing data only at server side. I am actually trying another approach to use some variables within my queries on the server to hopefully reduce two joins, if that works it is all sorted for this part ;) Thanks again.
Hi David,
Yeah, that is what I thought. SQL and data analysis is actually my primary profession. I work with health data and they grow so much so fast and their analysis is never straight forward so speed of the queries is always a worry for me as I have seen how slow they may become and how much memory they may consume!
Hi David, I know, my query at the server side already includes 6 sub-queries and joins and it worries me that when we have a large amount of data the complexity of the query may causes some delays in responding to the client. So in this instance lets say in a sample similar to Adrian's I have some data that I have assigned directly to the Report control from HTTPCLIENT. Before I display them I would like to run a SUM/Group by on the data and display the results at the same table or even elsewhere. It would help a lot if by any means we can run a SQL query on the received data from the API.
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.