-
Content Count
882 -
Joined
-
Last visited
-
Days Won
7
Everything posted by Stano
-
Excellent. I missed it, I didn't notice. He didn't understand.
-
TFDQuery (Master/Detail) with CachedUpdates Too Slow on Delphi 10.4.2
Stano replied to dataol's topic in Databases
I knew that something like that. I just didn't find it. -
TFDQuery (Master/Detail) with CachedUpdates Too Slow on Delphi 10.4.2
Stano replied to dataol's topic in Databases
Personally, I do not use DBGrid. There are always some problems with them. I use VirtalStringTree. -
TFDQuery (Master/Detail) with CachedUpdates Too Slow on Delphi 10.4.2
Stano replied to dataol's topic in Databases
I found a problem. It's in DBGrid. I threw away his DataSource and at the end Button1Click DBGrid1.DataSource: = dsQryItemReceita; It goes immediately. -
TFDQuery (Master/Detail) with CachedUpdates Too Slow on Delphi 10.4.2
Stano replied to dataol's topic in Databases
Um, it's programmatic. the data was displayed in the DBGrid in about 20 seconds. But something was still going on there. I canceled it after a minute This cycle runs relatively quickly for 6 seconds for I := 1 to 20 do begin qryItemReceita.Append; qryItemReceitaID_ITEM_RECEITA.AsInteger := I; qryItemReceitaID_PRODUTO.AsInteger := I; qryItemReceitaQUANTIDADE.AsFloat := 1; qryItemReceitaDESCRICAO_PRODUTO.AsString := 'PRODUCT ' + I.ToString; qryItemReceitaPRECO.AsCurrency := 2.00; qryItemReceita.Post; end; Here it hangs those 20 sec qryItemReceita.First; while not qryItemReceita.Eof do begin qryItemReceita.Edit; qryItemReceitaVALOR_DESCONTO.AsCurrency := qryItemReceitaVALOR_DESCONTO.AsCurrency + 0.1; qryItemReceita.Post; // This action takes about 3 seconds during the first cycle. At 20 cycles of 10 sec! qryItemReceita.Next; end; Try converting both cycles to batch processing (DMArray) -
TFDQuery (Master/Detail) with CachedUpdates Too Slow on Delphi 10.4.2
Stano replied to dataol's topic in Databases
I used Firebird-2.5.9.27139-0_Win32_embed files. Insert TFDPhysFBDriverLink on the form and enter VendorLib on the given files. He keeps reporting the same mistake to me. I do not know why. -
...sum(amount)... Group by customer having sum(amount)= 0
-
TFDQuery (Master/Detail) with CachedUpdates Too Slow on Delphi 10.4.2
Stano replied to dataol's topic in Databases
I'm missing TFDPhysFBDriverLink and TFDGUIxWaitCursor. I don't know if it will help. I can't try it. I have FB v3.07 Project Project1.exe raised exception class EIBNativeException with message '[FireDAC][Phys][FB]unsupported on-disk structure for file D:\DOKUMENTY\Z INTERNETU\TEST\TEST.FDB; found 11.2, support 12.2 IProvider::attachDatabase failed when loading mapping cache'. -
ExpressScheduler
-
FireDAC: Need help understanding "ConnectedStoredUsage"
Stano replied to Der schöne Günther's topic in Databases
Such things are basically done programmatically. This will give you full control over them. -
Turn off TDBGrid's automatic vertical centering of row already visible?
Stano replied to Tom F's topic in VCL
Does TD bGrid have the "center selected record" property? -
Vote for Segoe UI as Default Font opened.
Stano replied to KodeZwerg's topic in Tips / Blogs / Tutorials / Videos
https://www.xda-developers.com/microsoft-has-new-windows-10-build-refreshed-segoe-ui-font/ -
Prevent Alt or Ctrl + Print Screen
Stano replied to Henry Olive's topic in RTL and Delphi Object Pascal
I've added the ability to print every form everywhere. It hasn't been written about taking a photo of the screen yet. So it's a completely useless effort. -
I can't help but feel sick when I see sql.add (). The readability of the code is lousy I do not know if this also applies to your case. In general, a parsing of SQL text is performed after each sql.add. It is an unnecessary waste of system resources First, I compile the entire SQL text according to the user's choices and at once I assign the entire text to SQL. I usually have a separate function for each choice. So I won't get lost in it. I apologise. It happened by mistake.
-
Several F2084 Internal Error on Delphi 10.4.2
Stano replied to Davide Angeli's topic in Delphi IDE and APIs
Um, there are two patches. No. 4 and 5. First I installed no. 5. Maybe it won't matter. -
I know it. I have always respected copyright law. This is true even now. I'm canceling the offer to send books for sure. As written above: you can search for it on the internet.
-
I don't remember exactly which ones are paid. I definitely bought them. I don't have a document
-
I have these books. I think they are all free. I can send. I have only read a few. Baoquan Zuo Delphi Documentation Guidelines XML.pdf Borland Database Application Developers Book Delphi.pdf Breveglieri Marco Delphi Succinctly.pdf Cantu Marco Delphi 2009 Handbook.pdf Cantu Marco Object Pascal Handbook.pdf Cantu Marco ObjectPascalHandbook BerlinVer.pdf Cruysberghs Stefan Debugging techniques in Delphi.pdf Doeraene Sébastien Generics with Delphi 2009 Win32.pdf Gabrijelčič Primož Delphi High Perfomance.pdf Glowacki Pawel Expert Delphi.pdf Hodges Nick Coding In Delphi.pdf Hodges Nick More Coding in Delphi.pdf ObjectPascalHandbook SydneyVersion Complete.pdf Sedgewick Robert Delphi - Algorithms.pdf TsiLang Users Guide Lokalization application EN.pdf
-
I found that it is usually necessary to wait for the LSP to do nothing. See the small thermometer at the bottom right.
-
Display Componant like Gauges Led and Graphic for Delphi FMX
Stano replied to Remi1945's topic in I made this
At first I thought it was TMS -
FAST4/5MM ? 4 is free.
-
First line of Code Insight not selected (10.4.2)
Stano replied to FaFaFooey's topic in Delphi IDE and APIs
Personally, I am very annoyed by this behavior. I see the first line is what I need. I will automatically press Enter and NOTHING. -
Read and reapply design time properties to specific controls - runtime
Stano replied to aehimself's topic in VCL
A Tag can be used for this purpose. Unless it is used for something else. -
Amateur solution: recursively search the entire form and set the required