Posts by Edu Mendonça • 2,564 points
103 posts
-
3
votes2
answers2038
viewsQ: SQL Insert with line break
With this command SQL enter some data in the table, the problem is, in the system the field "ANDAMENTOS_PROCESSUAIS.OBSERVATION" is with line breaking and at the time of saving via SQL the line…
-
4
votes1
answer332
viewsQ: What is the difference between Charset : DOS850 x ISO8859_1 x WIN1252?
What’s the difference between these Character Sets: DOS850 x ISO8859_1 x WIN1252 because I see it at the time of creating a database and do not understand right what their differences? I know it’s…
-
1
votes0
answers276
viewsQ: What are the advantages and disadvantages of working with Firedac
There’s been a lot of good talk about fireDac but what are the Perks and Disadvantages to use it? Which databases are most suited to this technology?…
-
9
votes1
answer344
viewsQ: What is the difference between Collation UNICODE_CI_AI, UNICODE_CI and UNICODE
There is a difference between UNICODE_CI_AI, UNICODE_CI and UNICODE? What they are and what they interfere with in the database?
-
1
votes1
answer460
viewsA: Remove Down Arrow from a Combobox
The combobox is Very interesting, I tested here how you want it is worked... with style = csSimple. You plus it only completes with the names previously entered in the property Items.…
-
2
votes2
answers806
viewsA: Mathematical logic betting on the lottery
I’d be like this without pseudo code. var Premio, Apostador01, Apostador02, Apostador01, ApostadorPc01, ApostadorPc02,ApostadorPc03: float; leia Premio leia Apostador01; leia Apostador02; leia…
-
1
votes2
answers9328
viewsA: Firebird Tool - Which
There are some among them: EMS SQL Manager for Interbase/Firebird Free and Paid version. Ibexpert Free and Paid version. Advanced Data Generator and Database Workbench Free and Paid version. I find…
firebirdanswered Edu Mendonça 2,564 -
5
votes1
answer588
viewsQ: How to know which object is focused at runtime
I see you already have a question similar with mine only that is in C#. I’m doing a field check routine and when one of the date fields is empty it gives the message. I need that when one of these…
-
3
votes2
answers732
viewsQ: I opened a Form inside a Panel
Seeing a Question here on Stackoverflw where one of the answers was to open the Form within a Tpanel. It is possible to open a Form within a Tpanel? And if positive as one does to open a Form Within…
-
1
votes2
answers57
viewsA: Suspend Trigger on parole
For generic SQL, you can use CASE: CASE is used to provide type of logic if-then-else for SQL. Its syntax is: SELECT CASE ("column_name") WHEN "condition1" THEN "result1" WHEN "condition2" THEN…
-
2
votes2
answers943
viewsA: Disable automatic line break by indenting code in Phpstorm
I found this, if you follow the steps below you can disable... Enable automatic line breaking When the line is too long, if we want it to be divided automatically into several lines (from according…
phpstormanswered Edu Mendonça 2,564 -
2
votes2
answers131
viewsA: How to destroy activex component that is generating Delphi error?
The answer to your question has already been answered. See the link with the answer. Error closing form with Tacropdf in Delphi…
-
1
votes2
answers50
viewsA: Hide registration to the user
When trying to Delete check the status of the record, and if it is 1 updates to 0 and passes the bank pointer to the next record.
-
1
votes2
answers1642
viewsA: How to open files. GDB
To backup you will need a database system, an interesting option would be to use the Ibexpert. To download the free version, visit the link Ibexpert Download Center register to download.…
-
1
votes1
answer22
viewsQ: Database Text does not appear in Tdbmemo
I have a table that one of the columns is connected to a TDBMemo only that the text in the table does not appear in the TDBMemo when the table is open, both in Execution and Design mode. I’ve…
-
1
votes1
answer138
viewsA: Delphi 10 Seatle Error When Compiling Rxlib
I managed to solve it this way. I removed all references(Components and Uses) of RXLib old and put the components of the new version of RXLib and I compiled everything and it worked.…
-
1
votes1
answer821
viewsQ: How to make an Edit not lose focus?
How to make for a TEdit, that is being accessed on Android, do not lose focus because of the virtual keyboard that arises the moment the focus goes to the TEdit?
-
1
votes1
answer1184
viewsA: How to select Tedit field text in Delphi 10
Another thing set to SelLength a value greater than the number of characters of SelStart results in the selection of all characters from SelStart until the end of the text. TEdit(Sender).SetFocus ;…
-
1
votes1
answer234
viewsA: Display Hint on a disabled GRID
I don’t think there’s any way to show it Hint on disabled components. I needed something like this years ago...and I found in a forum a way around the situation and it’s quite simple. You will mask…
-
1
votes1
answer389
viewsA: Add Richtext Delphi line
Try it like this: Richedit1.SelAttributes.Color:=clBLue; // Cor Azul Richedit1.SelAttributes.Style:=[fsBold,fsUnderline]; // Negrito e sublinhado Richedit1.Lines.Add('Linha'); // Adiciona linha…
-
1
votes1
answer1943
viewsQ: Checkbox within a Dbgrid
I have a DBGrid in my project and I need it to have two columns with CheckBox. This project is aimed at VCL Form and use Firebird 2.5 database that has no fields Boolean. For the verification of the…
delphi-10asked Edu Mendonça 2,564 -
2
votes1
answer1438
viewsQ: Variable Declaration with Default Value in Procedures
You could declare a variable with a default value in Procedures? procedure TfrmManutencao01.FormShow(Sender: TObject); var lPriAber : Boolean = True; begin . . . end; I know that as it is above…
-
2
votes2
answers1981
viewsA: Locate for two fields
LOCATE - Declaration: function Locate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions): Boolean; virtual; This method allows the exact search of a record, for fields that…
-
1
votes2
answers1981
viewsQ: Locate for two fields
How to do a survey with Locate with two or more fields simultaneously? What are the drawbacks of doing this?
-
1
votes2
answers1468
viewsA: How to use Firebird WITH LOCK with Delphi Firedac
After Tanto Tentar I solved the question. In order to function in the FireDac will have to disable the Autocommit ex: FDConnection1.TxOptions.AutoCommit := False;. P - This eating blocks the table…
-
2
votes2
answers444
viewsQ: What are the advantages and disadvantages of creating a Windows service
I want to know the advantages and disadvantages of creating a windows service and if: If it’s easy to maintain; If anyone ever had a problem with that; If you require any specific knowledge, apart…
delphiasked Edu Mendonça 2,564 -
2
votes2
answers1468
viewsQ: How to use Firebird WITH LOCK with Delphi Firedac
I’m trying to Block a table on my system in order to prevent other users from entering the system when the procedure is running, how can I do this using the "WITH LOCK" with the "Firedac"? This…
-
1
votes0
answers104
viewsQ: How to Create a Temporary File on the Network
I wanted to know how to create a temporary file on the network. Every time the user logs in checks if the file already exists if yes the system creates another file with the different name. Every…
-
2
votes2
answers126
viewsA: Error opening form - Delphi
Complementing @Jonathan Cani’s reply: Install O RXLib that this component is part of this package. Download here or replace the component with a similar one...…
-
1
votes1
answer1209
viewsA: Configure Delphi Berlin for api 16 or 17 or 18 (Jelly bean version of android)
Look at this forum there explains how to configure the SDK of Android in the Delphi. In the site of Embarcadero also tells how to set up, but is in English. There’s also this youtube video that…
delphianswered Edu Mendonça 2,564 -
1
votes2
answers646
viewsA: Pick up Checkbox value from a form as Boolean for another form
Try it this way if SeuForm.CheckBox1.Checked = False then SuaVar := 0 else SuaVar := 1; Remember to put in implementation uses to Unit of Form where is the TCheckBox1 implementation {$R *.dfm} uses…
delphianswered Edu Mendonça 2,564 -
1
votes1
answer343
viewsA: Progress bar in console application in Delphi?
Try it like this: I saved this in a file because I was trying to do the same and it worked... I found this in a Forum at the time. Var cont, Linhas : integer; Lista: TStringList; begin try…
-
2
votes2
answers398
viewsQ: Exclusive access to a Chart in Firebird Got How?
Would Open a Table in Mode Exclusive in the Firebird for Delphi preventing other users from opening the Table? I use Delphi 10.1 and Firedac for connection to the database.…
-
1
votes3
answers4648
viewsA: Android Delphi-10 build error on Windows 10
Try Update Java as Mr. Luiz’s response if it doesn’t work try to update the Sdk and NDK the Way is: Tools > Options > Environment Options > SDK Manager. in the flaps Sdk and NDK and Java…
-
9
votes1
answer667
viewsQ: Firebird SQL and Union ALL without duplicating items
I have an appointment SQL searching in two table one leading and one of historical only when I run the query the values come duplicated I use UNION All because if I put the UNION or DISTINCT…
-
3
votes2
answers230
viewsQ: Sub-consultations with SELECT declaration in Sqlite
I have to return two values in my query and do not know if it is possible to do this in a single select... I wanted a better explanation to understand how to make a subselect on Sqlite. I have the…
sqlite3asked Edu Mendonça 2,564 -
3
votes2
answers3700
viewsQ: How to Format/Separate Date and Time from a sqlite datetime field
I have the table Pitches with the following fields: CREATE TABLE [LANCAMENTO]( [ID] INTEGER PRIMARY KEY ASC AUTOINCREMENT NOT NULL UNIQUE, [VALOR] DECIMAL(8, 2), [DATE_BUY] DATETIME, [DESCRIPTION]…
sqliteasked Edu Mendonça 2,564 -
1
votes1
answer294
viewsA: Error opening Delphi application in Windows Server 2008 R2 Standard x64
This occurs when the database is not found. check the route of the database.
-
2
votes1
answer3604
viewsA: How to get only time of timestamp?
This way you extract the Minute and Second Hour from the Field date and timestamp of the Firebird see Here Complete Content about extracting date and Time from the field timestamp SELECT EXTRACT…
-
1
votes2
answers304
viewsA: Createdatabase Delphi VCL
To complement the above answer Places a component of TFDQuery FDQueryclose; FDQueryclose.sql.clear; FDQueryclose.sql.add (' create table teste(' ); FDQueryclose.sql.add (' n_fields1 integer default…
-
1
votes1
answer294
viewsQ: Error opening Delphi application in Windows Server 2008 R2 Standard x64
Application Error Exception Eibnativeexception in module Autosad.exe at 003AF7F1. [Firedac][Phys][FB]Unable to complete network request to host "PROSYSTEM-01". Failed to locate host machine. The…
-
5
votes1
answer522
viewsQ: How to Change Server Type in Firebird 2.5 (- Superserver, Classicserver or Superclassic)
How to Change Server Type on Firebid 2.5? I know it’s three : Superserver, Classicserver or Superclassic
firebirdasked Edu Mendonça 2,564 -
1
votes2
answers498
viewsQ: Trying to Quickly Open a Huge Table with Fdtable
Hello, the problem I’m facing is: I have a table with 120,353 records need to make a general correction on the table and how hard I try FDTable.Active := True is in process endlessly... I’m using…
-
3
votes1
answer976
viewsQ: 'Could not Convert Variant of type (Null) into type (Double)'
if DataModuleGeral.tbHonorariosPERCENT_ADV_ASSIST1.AsFloat = 0 then begin DataModuleGeral.tbHonorariosPERCENT_ADV_ASSIST1.Value := Null; end; I have the above routine that when the percentage cap is…
-
1
votes1
answer163
viewsA: Error Editing or Deleting Items by Delphi 10.1 after Updating Firebird
After Tanto tried to verify that I had to update the Fields of each table then deleted each field of each tabla and put a new FDConnection update and delete functions are back up and running.…
delphi-10answered Edu Mendonça 2,564 -
1
votes1
answer163
viewsQ: Error Editing or Deleting Items by Delphi 10.1 after Updating Firebird
Hi, people I’m going through a problem I’m not able to delete or edit anything from the database by the system created by Delphi 10.1. This started to happen soon as I migrated from Firebird 2.1 to…
delphi-10asked Edu Mendonça 2,564 -
2
votes1
answer554
viewsQ: Query returning duplicate values
people I posted here on topic SQL query with duplicate items I just have another question... have a sql: SELECT TABNOV.CODIGO_ANDAMENTO, TABNOV.NUMERO_PROCESSO, TABNOV.INSTANCIA,…
-
2
votes3
answers1673
viewsA: Error giving post by Delphi
Searching further I found this on the site docwiki. The UpdateOptions.UpdateMode controls the generation of the clause WHERE to publish updates and exclusions. The default value upWhereKeyOnly uses…
-
1
votes3
answers1673
viewsQ: Error giving post by Delphi
I have a table that only has a record this table I save the system parameters it only has one item saved and its item number in one will be greater than 1 so she has no primary key, only when I try…
-
0
votes1
answer653
viewsA: Problem with Delphi 10.1 + Firedac (Autopost)
What if you so don’t solve it? I did it in mine and it works here for me. To Enable: DataModuleGeral.SeuBanco.TxOptions.AutoCommit := True; To Disable DataModuleGeral.SeuBanco.TxOptions.AutoCommit…