Posts by Caputo • 5,583 points
123 posts
-
2
votes1
answer262
viewsA: About Tadeventalert from the Firedac component suite. What is it and what is it for?
This component is used to receive SGDB-triggered notifications. These notifications must be implemented by the developer through triggers or stored procedures in the database. You can notify the…
-
2
votes1
answer308
viewsA: About the Tadcommand and Tadtableadapter components, what are they, what are they for?
The TADCommand is a component responsible for executing commands in the database, it cannot be used to provide content to Dbware components because it is not a dataset, its operation is similar to a…
-
0
votes1
answer69
viewsA: How to pass two tables to one and update codes
You can create a temporal field in the Frame table ALTER TABLE Quadro ADD cd_painelInteger Enter the records INSERT INTO Quadro (nm_medida, cd_progresso, impresso, entregue, cd_painel) SELECT…
-
2
votes1
answer965
viewsA: Zeos installation error in Delphi 7
According to him link taken from the forum of Zeoslib, in the post of Debian8 he said that this directive is really wrong and that he could remove without problem. said error was in this Unit: [DCC…
-
2
votes1
answer214
viewsQ: Save entities with one relationship to many using Webapi
I am starting a project in Webapi and came across a situation that did not know how to define my class of Controller. I have the following structure public class Artigo { public int ArtigoId { get;…
-
2
votes4
answers22316
viewsA: Subtract two TIMESTAMP and receive the value in minutes on Oracle
The answer to that question I take of this post of Soen If you multiply the interval by 24 and by 60, you get the number of minutes by extracting the number of days. It’s more compact, but I’m not…
-
28
votes7
answers2227
viewsA: Agile methodologies - a single programmer
The short answer to the question is Yes! I have a habit of picking up some freelance projects and what I do is use Scrumboard to control what I should do and Burndown to keep up with my expected…
-
2
votes2
answers2986
viewsA: Select a table that simulates a tree
I believe if you add one NOT EXISTS (SELECT 1 FROM @t c3 where c3.parentid = c2.id) in WITH tree (id, parentid, level, name , rn) as ( SELECT id, parentid, 0 as level, name, right(row_number() over…
sql-serveranswered Caputo 5,583 -
0
votes4
answers10133
viewsA: Develop iOS apps using Java
In this Link there is reference to a plugin called Codename One free of charge and open-source for eclipse or Netbeans that lets you develop in java for iOS In the website of them there are several…
-
2
votes3
answers6757
viewsA: How do I round up a value from 39.54 to 39
Just truncate the value: function trunc (n) { return ~~n; } Source: https://stackoverflow.com/questions/2125715/javascript-trunc-function…
javascriptanswered Caputo 5,583 -
1
votes2
answers3607
viewsA: What is the difference between using GDS32.dll and fbclient.dll and using . fdb and . GDB in Firebird?
When installing Firebird it offers to copy the dll as GDS32.ddl only for compatibility purposes, both are the same thing and therefore there is no difference. As for the extension, it also makes no…
-
6
votes2
answers1898
viewsA: What is the difference between Tsqldataset, Tsqlquery, Tsqltable and Tsqlsimpledataset components?
What is the reason for Tsimpledataset? The set Tsqlquery + Tdatasetprovider + Tclientdataset has many features and is widely used but, there are cases of server client applications where the…
-
2
votes2
answers495
viewsA: Serversocket IP lock?
Yes, it is possible. You can intercept the client connection in the Serversocket Clientconnect event procedure TForm1.ServerSocket1ClientConnect(Sender: TObject; Socket: TCustomWinSocket); begin if…
-
3
votes2
answers1316
viewsA: Auto Build Tool for Delphi
You can use Msbuild to compile any version of Delphi because it will compile by command line. follows an Overview with more data to use the build by Msbuild in this link of Engineering itself…
-
3
votes1
answer1315
viewsA: Monitor Service with Borland Socket Server
Below is an example of how to control connections: To record which users are connected, you need to use the server socket’s Clientconnect event and add the client to some object, list, or dataset…
-
8
votes2
answers3578
viewsA: How to encrypt using an asymmetric encryption algorithm in Delphi?
There is a suite of components called tpOnguard, which can be downloaded in this link for Delphi who has several ways to allow you to do this. an example below allows generating a key of 16 values…
-
3
votes1
answer1763
viewsQ: Self relationship at EF6
I need to make a relationship in one of the entities, as I do to reference the entity itself for both child records and parent record public class Comentario { public int IdComentario { get; set; }…
-
3
votes1
answer508
viewsA: How do the visual components of Delphi 2010 follow the visual standard of Windows?
You need to go to Project -> Options -> Application and select the option "Enable Runtime themes". Another option is to use a Txpmanifest component, which makes it always look like windows XP.…
-
0
votes2
answers5356
viewsA: Using methods from a DLL
You can create a class of your own to map the dll or load it dynamically First declare the type of function q vc you want to call type TTipoFuncao = function (sListaArqEntrada: BSTR; sArqSaida:…
-
0
votes5
answers2656
viewsA: How to manage a Sqlite connection between multiple simultaneous threads?
I don’t know much about android, but we have a desktop application that also uses Sqlite and the solution for using it in several threads was to create a class to be a Pool of connections and this…
-
2
votes3
answers1494
viewsA: Filter table before applying a LEFT JOIN
Not if it would be more performative but if it were executed the left join in the table already filtered as a subquery. I know that subqueries are not very performatic but as it is indexed can be…
-
2
votes1
answer2247
viewsA: How to stop a Thread for a certain time without using a Timer?
You can use the GetTickCount that returns a cardinal number containing the time in milliseconds since the system is turned on. Then, when you call again, just check the difference. Two important…
-
6
votes3
answers9879
viewsA: How to free all memory allocated by an object - Delphi
Taking advantage of Math’s answer, if vc simply set nil to the object it is still allocated, but vc is disassociating the variable pointer from the memory area occupied by the object. When you call…