Posts by adamasan • 2,069 points
23 posts
-
5
votes3
answers727
viewsQ: Is it bad practice to store CPF and CNPJ in the same column of the database?
In a flow that allows the registration of natural persons and legal persons I have seen the two approaches, but I’m not sure whether it is a good practice to store the two information in a column…
-
1
votes1
answer73
viewsQ: In a banking scenario with high transaction volume Code First can be higher than Database First or vice versa?
I am architecting the development of a backend structure composed of microservices for a financial institution. Probably the biggest project I’ve ever worked on, and I’m having serious doubts about…
-
1
votes1
answer104
viewsQ: Is it incorrect to state that in a stack-type data structure, the element that will be removed from the structure is the one that is stored in the header?
In a data structure proof I had the following question: In a stack type data structure, the element that will be removed of the structure is the one that is stored a) longer ago. b) less time ago.…
-
1
votes1
answer184
viewsQ: Would it be right to use a static class to consume a web service?
A question that occasionally arises when I am programming is related to the use of static classes. To official documentation Microsoft says the following regarding static classes: A Static class can…
-
1
votes1
answer74
viewsQ: "A data type is an abstract concept defined by a set of logical properties." - What does that mean?
I’m reading the book "Data Structures Using C", and one of the things the book explains is that a set of bits has no intrinsic meaning, and that the meaning of a given set of bits is given to this…
-
1
votes0
answers37
viewsQ: What is the difference between Jagged arrays and multidimensional arrays, and what application is indicated for each one?
I would like to better understand the difference between Jagged arrays and multidimensional arrays, and how each type should be applied in practice.
-
14
votes1
answer1374
viewsQ: What is the difference between a statement and an expression?
In the universe of programming these are two widely used terms, but sometimes I see people using them (sometimes even experienced professionals) as if they were interchangeable. Is that valid? When…
-
3
votes1
answer274
viewsQ: When consuming an API that returns me serialized data in JSON, how do I know the data types of the properties?
I have no experience with JSON or web services consumption, but I am trying to consume an API that gives me weather data. Here is the documentation of the API I’m trying to consume. This API returns…
-
1
votes0
answers51
viewsQ: How to migrate a local wordpress site to a commercial server?
I made a project of a site (basically bought a template and customized) in Wordpress locally on my machine, now I need to migrate this project to a commercial server on the web. How do I do it…
-
1
votes1
answer758
viewsA: List more than one table for a single sign-up screen
You didn’t specify the data access technology you’re using, but you, from what I can make out, need to establish a relationship between the resume table and the phone table and e-mail, a fairly…
-
25
votes4
answers4453
viewsQ: What are the practical advantages of using object orientation in the day-to-day life of a development team?
Work in a company that does not use object orientation, although the language allows (and encourage). I have studied and study object orientation, and do my personal projects in OO, but I do not…
-
23
votes2
answers4023
viewsQ: Can it be considered a bad modeling practice to store all people (customers, employees, suppliers) in the same table?
I am trying to design a database for a small project but I am having difficulties regarding the normalization of the tables of persons (physical and legal): Client Supplier Professional I thought…
-
0
votes1
answer2862
viewsQ: How do you check if a view exists before you have it created?
Take as an example the following view: CREATE VIEW vw_types AS SELECT codigo AS code, nome AS description, abreviacao AS abbreviation, statusRegistro AS status FROM tipos How can I have it created…
-
3
votes1
answer223
viewsQ: Configuring SVN in Amazon EC2 - User authentication is not requested
I’m having trouble setting up SVN on an Amazon EC2 server managed by Bitnami. I actually created this machine to use Redmine, but I’ll also need the SVN. I followed the instructions on the wiki…
-
3
votes1
answer78
viewsA: Access Violation in Code
You need to use for i := 0 to (ParamCount -1) do since if the number of parameters is 5, you will have to iterate from 0 to 4 (ie 5 iterations). The way you are iterating from 0 to 5 (6 iterations),…
-
2
votes1
answer181
viewsQ: Changes in source code are ignored by the compiler
I have a little project in Delphi 2006, and I migrated it to Delphi XE6. However, from this migration, I realized that the changes I make in the source code, such as changes in the form title,…
-
-1
votes1
answer473
viewsQ: Dreamspark License - Can I use on more than one machine?
I have a license from SQL Server 2014 Enterprise and one from Visual Studio 2012 Ultimate, both obtained through Dreamspark. As I did not know that in the future I would need them on two machines, I…
-
5
votes1
answer7721
viewsQ: How to change the language of Microsoft SQL Server Management Studio?
The image file . ISO of Microsoft SQL Server 2014 Enterprise available for download through Microsoft Dreamspark exists only in version en. Could you change only the language of the Management…
-
8
votes3
answers4774
viewsQ: How to improve file recording speed for a Clientdataset?
I’m integrating a system with a bank file, and I’m having a problem with the process. I receive from the credit card operator a plain text file with approximately 1300Kb and about 5,500 lines. I’m…
-
70
votes7
answers21276
viewsA: Best kind of data to work with money?
Friend, I leave here some of my experience, work with commercial automation systems using Microsoft SQL Server, and I strongly suggest that you use monetary fields with type DECIMAL. In the company…
-
0
votes2
answers1492
viewsA: Open Outlook by clicking an email on the Tdbgrid component in Delphi
Some time ago I had a similar need and managed to resolve with based on this response of Sertac Akyuz in the SOEN using the Mailitem.Display. Basically you need to declare Unit ComObj and create a…
-
6
votes2
answers3255
viewsQ: How to perform object persistence in Delphi database?
I work with Delphi, but always in a procedural way and using Data-Aware components. I recently started reading some things about working with POO at Delphi, and did some fairly basic examples, my…
-
12
votes1
answer409
viewsQ: Is it possible to integrate SVN with my task control tool?
I have a development environment with an SVN server running with Visualsvn and terminals with Tortoisesvn. In this same environment I have a task control system, done in Delphi, in which the tasks…