Posts by EMBarbosa • 748 points
27 posts
-
1
votes2
answers181
viewsA: Package usage difference in Delphi/Lazarus and Java
Indeed, in Delphi, normally Packages are created to be reused. Packages are treated as a framework. This does not mean that you cannot modularize your system using Packages if you wish. But if you…
-
2
votes1
answer522
viewsA: How to Change Server Type in Firebird 2.5 (- Superserver, Classicserver or Superclassic)
The way to change the architectures is to uninstall and install again. This is done in a matter of minutes and the banks will work normally after. Depending it may be necessary to make some…
-
1
votes2
answers1314
viewsA: Connection limit
There are no connection limits in Firebird itself. Still other factors may limit the number of connections allowed. See: Operating System Most systems have a limit of 1024 simultaneous connections…
-
2
votes4
answers2076
viewsA: How to check if IP exists with bat
Unfortunately, is not possible do this in a common network. There’s nothing on the network that will tell you which Ips exist. But even if it existed, to know if the address is online you would need…
-
2
votes3
answers588
viewsA: Open as an administrator only the first time in Delphi.
Unable to open the privilege application only the first time if it already loads the manifest to open high. Also not interesting you start the high application and then run it without privileges.…
-
1
votes1
answer119
viewsA: It is possible to generate a file . CSV from a table of a Firebird database
Yes. Virtually every administrative tool exports. For example, the Fbexport can do this.
-
0
votes2
answers943
viewsA: Adding Hours greater 24 h
The guy TTime is used to represent a hour specific. If you want to represent a time period you should choose other options. I thought at least two: Utilise TTimeSpan - that in accordance with the…
-
1
votes2
answers1309
viewsA: Why put COMMIT at the end of the script using the Firebird database
Firebird is a database transactional. It means that everything runs within a transaction. Commit confirms changes made in the context of a transaction. RollBack does the opposite, undoing the…
-
1
votes2
answers439
viewsA: Why Delphi/pascal builders cannot be private like in C++
Contrary to what you mentioned, you can declare a private constructor in Delphi. See, the code below simply works: program Project2; {$APPTYPE CONSOLE} uses SysUtils, Unit1 in 'Unit1.pas'; //var…
-
1
votes1
answer1378
viewsA: Log system exceptions using application events
Create a Unit with the code that logs and calls it from try...Except that treats error and does not make a raise. Example: procedure FazLogException(NomeArquivo: string; E:Exception); var Arquivo:…
-
1
votes1
answer373
viewsA: How to concatenate two lists efficiently?
I could not reproduce low performance even with 3 thousand elements per list. Also the order is being maintained. I believe other things are interfering with your code. See the code below: program…
-
1
votes2
answers2315
viewsA: Numeric Overflow with Numeric(18,7) in Firebird
Your problem is common when dealing with this type of data. It turns out that the result of a multiplication Numeric(18,7) * Numeric(18,7) is larger than the Numeric type can accept. In a…
-
0
votes2
answers1435
viewsA: Maximum size for stored procedures, Fields, etc... in Firebird
There are two types of identifiers: regular and delimited. They have different rules of use. Delimited identifiers are only available in dialect 3. But just talking about boundary, the limit for…
-
0
votes2
answers7137
viewsA: Error in registering a Firebird 2.0 bank in Ibexpert
The first error occurs because the gds32.dll file was not available in the version used by Ibexpert which is 32 bits. The second error occurs because, although the fbclient.dll library is available,…
-
2
votes3
answers2378
viewsA: How to list files and subdirectories in Delphi?
Since you did not specify what type of component should be displayed, in the example below this is done using a Ttreeview. You will need a Ttreeview and a button in the form. Source:…
-
3
votes1
answer483
viewsA: Migration, Delphi and Firebird. What is the correct way to deal with the Encounter issue?
You can continue using WIN1252 in Firebird. It will make no difference in this issue.
-
2
votes3
answers3422
viewsA: Difference between Getter Setter and Property in Delphi
Your difficulty is precisely because you’re not used to seeing the code like this. Apparently, Java had no properties before and that’s why it uses getters/setters. Some advantages in using…
-
1
votes2
answers993
viewsA: How to program mobile with Delphi?
It is not possible to develop for Android with Delphi XE4. But from Delphi XE5 (Oct/2013) this is possible. The current situation is in the response of @Meuchapeu. The name of "framework" used for…
-
4
votes3
answers1786
viewsA: Form always visible
IS impossible to do that. Not only in Delphi, but in any application. Imagine if two apps did this. You would have two windows marked to be always as always visible and then as you would decide…
-
1
votes3
answers1277
viewsA: Reading in Delphi XML generated in Excel
You can use the utility Xmlmapper for map the data from the XML file to a Tclientdataset. From there you can import the data into Tclientdataset and manipulate.…
-
1
votes1
answer181
viewsA: Changes in source code are ignored by the compiler
You mentioned the executable, but are the . dcu files being changed? You have more than one copy of the code on your pc? It turns out that Delphi may be using old bpls or dcus files and not redoing…
-
2
votes3
answers1370
viewsA: Use of parameters in the "in" clause in a Tibquery
There is no way to do what you want using parameters. Parameters don’t work that way. You can try some alternatives, as: Change the SQL "in hand" as Filipe Fonseca replies Use temporary tables and…
-
2
votes2
answers5427
viewsA: How to extract blob files in Firebird?
As far as I know, this is not possible for individual files. Ibexpert has ways to export the blob files to a file of type .lob. But the idea is that they are used for import in another BD and not…
-
3
votes2
answers1731
viewsA: How to handle dependencies (DLL’s) in Delphi/Lazarus?
The normal is that you know which dlls your software depends on. It doesn’t make sense for your software to depend on a dll and you as a programmer not to know this. Some options however are: In…
-
4
votes1
answer3149
viewsA: Digital signature of software
You actually created several questions that might be best explored if they were separate. But I’ll try to answer anyway. Roughly, digital signature It would be like firm recognition and notarization…
-
3
votes4
answers1842
views -
1
votes2
answers690
viewsA: What is the cause of using SELECT null FROM RDB$DATABASE
Not at first, none. When it comes to SQL, taking into account the versions 2.0 from Firebird, the code you showed is no better than the code below: SELECT CK.IDCHEK, CK.DESCHE, null AS ENTEGU FROM…