Posts by Ricardo da Rocha Vitor • 360 points
20 posts
-
1
votes0
answers512
viewsQ: Api Mercado Livre
For about 4 months I’ve been studying the Free Market Api at Delphi but the yield is slow. Has anyone ever managed to authenticate and integrate the system? Use Rest and firemonkey.
delphiasked Ricardo da Rocha Vitor 360 -
0
votes3
answers3133
viewsA: View Form with animation (gif) while a while runs
Delegate the processing to a thread in the background. You can do this using German methods: TThread.CreateAnonymousThread(procedure () begin TThread.Synchronize (TThread.CurrentThread, procedure ()…
-
1
votes1
answer412
viewsA: Join 2 SQL with different results
Thus SELECT SUM(Temp.ordem) as ordem, sum(Temp.sistema) as sistema from (SELECT COUNT(a.arquivada=1)AS orden, 0 as sistema FROM tbl_os o INNER JOIN tbl_clientes c ON(o.tecnico = c.id) WHERE…
-
1
votes2
answers8954
viewsA: Calculate distance between two points by latitude and longitude
Follow the full code based on the contribution of colleague Tmc, ready to test In a blank form: copy the code below and press Ctrl+V (Paste) object Edit1: TEdit Touch.InteractiveGestures = [LongTap,…
-
0
votes3
answers3031
viewsA: What better way to create an app that works offline and automatically encrypt data with a server?
In fact, what is difficult in your question is more in relation to the many ways that Delphi allows to do, that choosing the best really depends on each particularity. For example, Delphi is very…
-
1
votes1
answer428
viewsA: App hangs when giving create in Datamodule
I was able to identify the problem. While testing the APP in designtime, I forgot an open table and, as the mobile path of the bank was different, so the application crashed, because I was looking…
-
1
votes8
answers3166
viewsA: Fewer moves from a horse to a given house in Chess
Without answering the question, but trying to contribute to the topic, I did a function that initializes the movements of the horse, making the next steps faster Calculate Destination for the horse…
-
3
votes4
answers898
viewsA: SQL Count Parole
SELECT data, COUNT(valor) FROM treatment_output --WHERE valor = 0 GROUP BY data,valor ORDER BY data
sqlanswered Ricardo da Rocha Vitor 360 -
1
votes1
answer81
viewsA: Advanced SQL query with dates
SELECT * FROM minha_tabela WHERE ( DATEDIF(CURDATE(),Data_operacao) <=5 AND WEEKDAY(Data_operacao)=5 ) OR ( DATEDIF(CURDATE(),Data_operacao) <=4 AND WEEKDAY(Data_operacao)=6 ) OR (…
-
1
votes2
answers1159
viewsA: API mercadolivre does not return JSON
I just put "application/json" on RESTClient1.accept and it worked.
-
-1
votes2
answers554
viewsA: Update and Insert data into a table with information from another bank
In my head Voce needs to use a RAD, like Delphi for example and there are several file batch techniques. Actually in Delphi it is very simple to do this and I am working on a project that integrates…
-
0
votes1
answer428
viewsQ: App hangs when giving create in Datamodule
I am creating an Android application in delphiXE7 and everything works until I will create dynamically the datamodule. Then it hangs and does not come back. procedure TForm1.Btn1Click(Sender:…
-
3
votes2
answers1873
viewsA: Can Sqlite be considered a relational database?
Of course. Like any other relational scheme, Sqlite offers processes of validation, verification and guarantees of data integrity, Support for foreign keys, Trigger and auto-increment competition…
-
0
votes2
answers1159
viewsQ: API mercadolivre does not return JSON
When I glue the address https://api.mercadolibre.com/sites/MLB/categories in the browser I see that the restfull API of the free market returns the data in JSON format, but when accessing the same…
-
4
votes1
answer2756
viewsA: What is an Associative Table?
The cardinality N to N leads to the logical model the need to define yet another entity. We call this ASSOCIATIVE. In other words, this occurs in cases where Voce intends to perform a relationship N…
-
1
votes1
answer601
viewsQ: How to synchronize auto increment keys between different databases in Firedac?
I am researching how the auto increment fields work in Firedac, using Delphi xE7 and managed to assemble an example of the documentation that synchronizes two master-details tables with the correct…
-
2
votes1
answer191
viewsA: Doubt referring to circular Referral of type customer <-> room
The correct thing, in this case, is to create the Tsala class as a Tpessoa Collection (or, the room class has a field that points to that Collection) You can paste a lot of code if you already do…
delphianswered Ricardo da Rocha Vitor 360 -
1
votes3
answers810
viewsA: Multiple lines on a Showmessage in Delphi
Simple! Add the character #13 (enter) at the end of each line. But first, create a temporary variable to accumulate messages, and display them at once at the end of the process //procedure1 para…
-
0
votes3
answers75
viewsA: Conditional for registration selection
Do the "max" on the start date. SELECT DISTINCT *, idprofissional, funcao,Max(Inicio) GROUP BY idprofissional
-
1
votes2
answers205
viewsA: Alert p/o programmer when opening Form (Designer)
Use a build directive on OnCreate form: Interface {$I YourInc.inc} Form.Create(Sender:TObject); Begin {$IFDEF DESIGNTIME} showmessage('alguma coisa'); {$ELSE} // o código normal em tempo de…
delphianswered Ricardo da Rocha Vitor 360