Hello Markus, I just found out that the locate wasn't working properly with 3.09 ex. mds1.SortOn('DESCRIP', []); mds1.Locate('DESCRIP', eRech2.text,...
Hi I've a kbmMemTable (kbmPhrasen) with about 3500 records. The fields are like this: SDPHPNR AutoInc-Value SDPHPAR Parent-Record (SDPHPNR, or if Top-Level...
Hi Dominik, first try persistent fields, NOT using FieldByName(...). The FieldByName... construction is VERY time expensive, _especially_in_loops_ !!! For...
... The major fault is that you use a new table and fill it into each iteration. you need a buffer for the generated nodes and then walk this buffer and add...
Dominik, After reading Franz-Leo's message, I'm sure, that my assumption about function Insertnode() was'nt accurate, and my "solution" is obviously "off...
Hi As Franz Leo has stated your code is slow because of the temp table (you could also globally declare some field pointers once) ie Var SDPHPNRField: TField ...
Hi ... and ... buffer. ... I have changed the code and use the nodes as Buffer. It is a bit faster, but not a lot. Due to the fact that the tree has only about...
Hi, Another approax might be to use VT as Virtual tree and just store the recordnumber in the data. VT will then only retrieve data when it needs to repaint...
Dear Dominik Hi! If you get the help file ($15.00), there are a number of tricks. They include: - Use FieldByName once for each field to create a field object...
... Uh... there's not much point advertising the help file if you're going to provide all of the [useful] answers it provides. Either way, the solutions you...
Hi! I am using OnCalcFields to fill in a 40 character wide string field on a table of about 32000 records. On a large display, when using a dbgrid, the...
P.S. Regarding the question below, I put a counter on the recalc calls and got over 750,000 in just several seconds of paging up and down the grid. That...
Using v3.00 under BCB4, I have TableA attached to TableB. When I set a range on TableA using SetRangeStart...SetRangeEnd...ApplyRange, nothing happens - all...
Phil Since it is a memtable then why use a calculated field? (This is the conclusion I've come to anyway), A 'temporary' field updated at the relevant times...
... Good comment - But there are many trade offs. If I am dealing with a table with a small number of records and the calculated values don't change then I...
Dear Neven Hi! I was using a calculated field since there are about 2000 lookup values versus about 32000 records that need to lookup the value. And whenever...
Hi! The other day I emailed the group a question about perfromance (see below) with calculated fields. When I removed setrange and instead used a findnearest...
Phil The basic problem with OnCalcfields is that it has to be called indicriminately (as you have found) as it cannot make any assumption about what determines...
Phil, ... any If you have to have recalc on fetch, you have to try to speed up the calc as mutch as possible. If data is needed from other database then be...
Jens, ... Yes, set LocalFormat in OI, and set your date separator to your own format just before saving, and restore it after saving. If you are not running in...
Phil, thanks for feedback. ... below) ... The latest version use index (if available and active of course) for SetRange. Also avoid filters, if you really have...
Dear Wilfried Hi! I tried all of those things; it turns out that the problem was not in the calculations but that the SetRange I was using to restrict the...
Hello, I was looking over the code and was wondering about a piece of coding in TkbmCustomMemTable.CopyRecords. At the end of the While loop, there is the...
Hello, When creating a kbmMemTable is the following manner "<var> := TkbmMemTable.Create(nil);", the compiler warns of "Constructing instance of 'TkbmMemTable'...
I am with difficulties in if creating one table with 05 indices. Sera that alguem could pass me some example as I can make one table would temporaria using 05...
I am with difficulties in if creating one table with 05 indices. Sera that alguem could pass me some example as I can make one table would temporaria using 05...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
