Posts by wBB • 518 points
53 posts
-
0
votes1
answer29
viewsQ: Slow problem with CAST in consultation
I need a help in a data conversion that I imagine is the problem of slowness in a query of mine. I am using Mysql 5.6. In the second query below, in the return of the MRESULT variable, when I use…
-
1
votes0
answers98
viewsQ: How to reduce Mysql query execution time?
In a Mysql database 5.6 I have two tables, TAB_A and TAB_B, whose relation is from 1 registry in TAB_A to "n" records in TAB_B. I am making an appointment as indicated below. When the TAB_A table…
-
0
votes1
answer1130
viewsQ: How to use Tformatsettings in Delphi 10 Tokyo?
How do I set regional date, time, decimal separator, mile separator settings in Delphi 10 Tokyo? Previously, in Delphi 7, there were global system variables. In newer versions they created the…
-
0
votes1
answer394
viewsQ: How to consume an authenticated service with Oauth2 on Nodejs?
I am trying to implement Oauth2 authentication in a REST Nodejs application with Express + Passport. My REST Nodejs application will be an API for a service to be consumed by a mobile application,…
-
1
votes1
answer143
viewsQ: Is it correct to create two servers in the same Nodejs app with Express?
I am creating a Nodejs application with Express and I am looking to observe all the "best practices" recommended for system security. In this system I’m thinking of having two open ports (but I…
-
2
votes1
answer135
viewsQ: Nodejs: How to keep an updated list accessible between files
In a Nodejs application with Express/EJS, I need to keep an updated list and I would like that whenever the user accesses my root route, that is the INDEX page, he could see this updated list. To…
-
0
votes1
answer211
viewsA: How to establish SSL/TSL socket connection with Nodejs
/* DOCUMENTAÇÃO DE REFERÊNCIA: https://nodejs.org/api/tls.html#tls_tls_createserver_options_secureconnectionlistener https://nodejs.org/api/tls.html#tls_tls_connect_options_callback Este exemplo foi…
-
0
votes1
answer211
viewsQ: How to establish SSL/TSL socket connection with Nodejs
I created a very simple server socket with Nodejs (V8.11.3) and it is working OK apparently. My goal is to keep an open socket connection continuously with an electronic device (Iot). QUESTION: How…
-
0
votes1
answer28
viewsQ: How to disable Angular comments
I’m starting to study Angular (current version) and I checked that after all the codes are compiled, the development information comments I put in the archives .ts are replicated to the files .js…
-
1
votes2
answers1398
viewsQ: How to change the background color of a Listview list item in Delphi 10
In Delphi 10 with Firemonkey, at runtime I need that when clicking on a list item of a Tlistview, the background color of this item be changed and remain so even if I click on another item. Then,…
-
0
votes2
answers412
viewsA: RFID BLUETOOTH PHP
Check the page server permissions (on the machine where you run PHP), because this permission error you are seeing must be coming from there... Other things: 1) I don’t know where you are now, but…
-
0
votes0
answers79
viewsQ: Handle data between enumerated variables and "set of" in Delphi
I have two variables of different types, but dependent, one type being a set of of the other kind which is a Enumerated Types. How do I extract the value from the type variable set of (Y in my case…
-
3
votes1
answer1184
viewsQ: How to select Tedit field text in Delphi 10
I have a very basic problem and I can’t figure out the cause... I need the text from within a Tedit to be whole selected when the field receives focus. In the times of Delphi 7 with VCL I was only…
-
1
votes0
answers1737
viewsQ: What is the correct way to interrupt a thread in Delphi
I am creating a thread with the basic information and structure as indicated below. Apparently everything is working well, but I noticed that when executing the Terminate, thread does not pass…
-
0
votes1
answer298
viewsA: How to pass the reference of an object?
I believe you’ll have to use ForceQueue instead of Queue, also noting that you will probably have to use Synchronize in your anonymous database, since you are updating external lists to the thread.…
-
4
votes1
answer2281
viewsQ: Regex no Delphi
A help with regular expressions in Delphi 10 please. I need to check the following on a string: Size ranging from a minimum of 6 characters to a maximum of 20 characters; Character type: a-z or A-Z…
-
0
votes1
answer329
viewsA: Delphi with Tmultiview does not get desired height
Just to mark the question as answered and resolved, but giving due credit to @Júniormoreira, the problem was solved only by setting the property Height = XXX pixels in Multiview, but at runtime.…
-
0
votes1
answer815
viewsA: How to edit Listview items at runtime (Runtime)
Edit the size of the texts until I understand, but "edit position"? What exactly means "edit position"? To edit the text size you can use the Substring function, as I added below in the Help…
-
0
votes1
answer329
viewsQ: Delphi with Tmultiview does not get desired height
I’m having trouble defining the height (Height) for a Tmultiview that is set to "arise" from bottom to top (property DrawerOptions -> Placement = Bottom). My Android app gets the screen…
-
2
votes1
answer3507
viewsQ: How and where to create files on Android with Delphi
In my application in Delphi I am creating a simple text file on Android, using the following code: var lst: TStringList; begin lst := TStringList.Create; lst.Clear; lst.Add('a'); lst.Add('b');…
-
1
votes1
answer1774
viewsA: Remove components at runtime in Delphi with Android
Already solved. For Android the release function of the memory component and consequent screen deletion is the DisposeOf and not Free, as I used to use in VCL components. Help from Delphi says the…
-
1
votes1
answer1774
viewsQ: Remove components at runtime in Delphi with Android
When creating a Tbutton dynamically at runtime within a Tvertscrollbox. When I need to delete this button it does not disappear from the screen. This problem only occurs by running the application…
-
0
votes1
answer328
viewsA: Error creating new screens in Delphi for Android
I have already solved and used a solution different from the one posted by the author of the other similar question. I just added Application.RemoveComponent(Application.Components[i]); to my Forms…
-
0
votes1
answer328
viewsQ: Error creating new screens in Delphi for Android
I’m creating an app for Android with Delphi 10 Tokyo and in this app has a certain screen, called Tela1. When I click the Open button from my menu on the main screen, calling the screen Tela1, opens…
-
1
votes1
answer1668
viewsQ: How to Interrupt setInterval in Javascript?
how do I interrupt the execution of a setInterval that is running on a module that I no longer need? I’m not talking about just catching the feedback from setInterval and execute a clearInterval.…
-
0
votes1
answer85
viewsQ: APP nodejs: prevent logs in terminal window
I created an application in Nodejs with Express and when I put this application to run (with npm start), There are some logs appearing in the terminal window where I am connected to each page that I…
-
0
votes1
answer69
viewsA: In Javascript, how to access data from an array using PUG/Jade view?
Correct form: view Pug. script(type='text/javascript') | var dataValues = valoresDoBancoDeDados; | var dataLabels = labelsDoBancoDeDados; include ../public/javascripts/chart-gen.js…
-
1
votes2
answers2000
viewsA: Generate and format dates with Moment in Nodejs
Considering a variable "data1" which is an object of type Date is already with the correct date in question, which in this case is 25/07/2017, just do the following: // data1 já é um objeto do tipo…
-
0
votes1
answer69
viewsQ: In Javascript, how to access data from an array using PUG/Jade view?
I’m using Express in Nodejs and I also use PUG (or old Jade) in views. In a view I display the data taken from a database on a graph. I already receive the data in array format. I created a small…
-
0
votes1
answer106
viewsA: Date field with jQuery does not arrow the chosen value
I got it. In the fields input text from and input text to was missing the attribute value="". So he stayed : <input type="text" id="from" name="from" value=""> <input type="text" id="to"…
-
0
votes1
answer106
viewsQ: Date field with jQuery does not arrow the chosen value
I am using a datepicker jQuery-UI to generate date in an "input text" field, but I cannot make the date selected in the datepicker set in that input and I do not understand what is wrong. What is…
-
3
votes2
answers2000
viewsQ: Generate and format dates with Moment in Nodejs
I’m trying to use the Moment for formatting dates this way YYYY-MM-DD HH:mm:ss and would like to determine a period between 00:00:00 yesterday and 23:59:59 today. Example: considering today as…
-
0
votes3
answers634
viewsA: How to read key and value from a json string?
@Taissonmartins, looking at the tags of your question I’m imagining that you can also use Javascript, so although you already got the answer you needed, here’s another option. I separated your JSON…
-
1
votes1
answer2316
viewsQ: CRUD Mysql with Nodejs: how to use Pool correctly?
I created two file to test the use of Mysql with Nodejs as follows below, but I’m finding the answer a little slow and I think I’m doing something wrong: DOUBTS: 1) Is this the most correct way to…
-
0
votes1
answer130
viewsA: Error converting String to Integer type in Nodejs
I figured out where the mistake was. // Eu estava fazendo isso ERRADO!! var j = { "IO_opened": '"' + ioOp + '"', "IO_closed": '"' + ioCl + '"' } // CORRIGIDO: Agora funciona var j = { "IO_opened":…
-
0
votes1
answer130
viewsQ: Error converting String to Integer type in Nodejs
in Nodejs I am trying to check the value of a variable of type String, but for some reason nothing is working. Example: var aaa = "0"; // Eu recebo essa variável como string (não dá para mudar o…
-
1
votes2
answers1099
viewsQ: Include or Require in Nodejs to separate codes
Hello! I wonder if in nodejs it is possible to separate some codes in different files as this example below, and how to do this: Currently I have only one file this way: File 111.js var app =…
-
3
votes2
answers497
viewsQ: How to reload the page in Express / nodejs
I created a new project with Express and Nodejs, where I set a "/status" route. Each time this route is accessed, you must execute a routine in the script /routes/status.js. Example: If I run a F5…
-
1
votes1
answer3849
viewsQ: Run a shell script with Nodejs
I need to create a page using nodejs, which will contain a "Turn on/Off" button. By pressing this button I intend to make the call from the same route, but passing a parameter: on/off or 0/1, etc..…
-
2
votes2
answers1155
viewsQ: Mysql with Nodejs: insertion of records
I created a script called 'test.js" just to demonstrate a simple insertion of log records into a Mysql database, using Nodejs, as follows. Will be generated around 5 logs per second, which makes me…
-
1
votes2
answers510
viewsA: How to select data from the previous month and year?
There’s only one "OR" missing there: SELECT SUM(valor_pag) FROM controle WHERE (MONTH(data_paga) < 07 and YEAR(data_paga) <= 2017) or (YEAR(data_paga) < YEAR(now()))…
-
0
votes0
answers303
viewsQ: Installation of Mongodb in Debian
I am trying to run Mongodb on Debian Jessie and apparently install everything correctly, but when I run it gives errors as indicated below. I don’t know if it’s relevant either, but following the…
-
0
votes1
answer139
viewsQ: Table with PUG in Nodejs
I am using PUG template in Nodejs and I am looking in the documentation how to assemble a table. I am checking in "pugjs.org", but apparently there is... Does anyone know how to mount a table with…
-
0
votes2
answers326
viewsA: nodejs, jsPDF and Windows
For registration only: I was able to run the PDF generation, but not via normal installation with npm install. I did the following: 1) I downloaded the jsPDF master ZIP file on Github, in the…
-
0
votes2
answers326
viewsQ: nodejs, jsPDF and Windows
I am unable to install jsPDF in my nodejs with npm. I have npm install node-jspdf to work with nodejs, but does not install because it gives problem when running the file install.sh. Even specifying…
-
0
votes0
answers230
viewsQ: ADO Recordset returns nothing
I can’t get ADO Recordset to return records from a Mysql table. I’m using VB.NET in Visual Studio. I can establish the communication with the database, make the connection, create tables, all via…
-
2
votes1
answer814
viewsA: Error opening Mysql connection via ADODB
I already took care of it. I downloaded the previous version of the Mysql driver, Connector/ODBC 5.2.7, for 32-bit and recreated the DSN in "ODBC (32-bit) data sources" in the Windows 10…
-
2
votes1
answer814
viewsQ: Error opening Mysql connection via ADODB
I’m trying to connect an application made in VB, Visual Studio 2017, using ADODB as a connection, but it is with several errors for different connection options. Already anticipating me, I checked…
-
2
votes1
answer2066
viewsQ: Mysql does not install
I am trying to install Mysql on Windows 10 and Microsoft Visual C++ 2013 is requested as a requirement. I have the latest version of Visual Studio installed and as a consequence were installed also…
-
0
votes1
answer658
viewsQ: Pass parameter in FILTER of a Javascript array
I need to pass a parameter to an external function I want to create for a filter array, but do not know how to do. Example: This code already works: const myArray = [ { "name": "nome1" }, { "name":…