Posts by Francisco Thiago • 81 points
11 posts
-
0
votes2
answers629
viewsA: Recover Auto Increment Id from Datasnap Delphi XE3
The most indicated way for you to do this is by making event use [BeforeUpdateRecord][1]. In this event you can change the Delta that is being sent to the bank (controlling even the type of change…
-
0
votes2
answers798
viewsA: Apache + Delphi XE7 + Datasnap. Memory problems
The above solution is very good, but to be used in the customer. On the server, if larger searches are made, it will be difficult to have memory for everyone. On the server, prefer to use as little…
-
0
votes2
answers408
viewsA: Problem to destroy Delphi’s DM
Based on what you describe and without the code to know what you are doing, it is a little difficult to help you. But come on. One approach would be to put, in these DM’s, the basics of the basics.…
delphianswered Francisco Thiago 81 -
0
votes1
answer336
viewsA: Problem when deleting from memory a Tobjectlist<Tlabel>
You are assigning nil for the variable before executing the DisposeOf. You would have to do this assignment only after performing the memory release method. Still, I think you should call the method…
-
2
votes0
answers1332
viewsQ: How to create Tdatasetfields in Tfdmemtable at runtime
With Clientdataset it was possible to bring a Tdatasetfield field with another data structure (another table) internally. This was done automatically by Tdatasetprovider. I’m migrating to Firedac…
-
3
votes2
answers692
viewsA: How to disable Autocommit in Firedac
I think it’s worth noting that the option AutoCommit simply clears the Updatstatus of the records. Other than ApplyUpdates of ClientDataSet, that returned all records to usUnModified automatically,…
-
0
votes3
answers343
viewsA: Release object into a function - Memory Leak
When it comes to Tfdquery, prefer to use . Release instead of .Free. The . Release calls, internally, some routines for data cleaning that Tfdquery calls while processing the request among other…
-
1
votes0
answers768
viewsQ: Fdmemtable losing data while using Filter
I created an Fdmemtable, at runtime, with the following structure: Cds_NaMenu := TFDMemTable.Create(nil); Cds_NaMenu.FieldDefs.Add('ID', ftInteger); Cds_NaMenu.FieldDefs.Add('MN_TELA_CODIGO',…
-
1
votes4
answers2460
viewsA: How to check for changes in a Clientdataset
A more complete solution would be to use the ClientDataSet.UpdateStatus. For each record, it informs if it has been entered (usInserted), edited (usModified) or deleted (usDeleted, but to see it,…
delphianswered Francisco Thiago 81 -
0
votes2
answers1047
viewsA: Generate Sequence Records with Clientdataset (Multiuser)
Your mistake is to use select Max() to increment the key. Since transactions see different versions of data until they are committed, each transaction will return the same value in Max(). That’s why…
-
1
votes2
answers1390
viewsA: Is Locating a Clientdataset very expensive?
It is more expensive in processing. Mainly because with each new execution of locate, you would have to position the record at the beginning of Dataset. A better option would be to use Findkey([]).…
delphianswered Francisco Thiago 81