Hello All! á small question: how to sort some fields on Ascending and Descending simultaneously ? example: Table_my.SortOn('field1;field2;field3;field4',...
Hi Use SortOn('field1;field2:D;field3;field4:D',[mtcoCaseInsensitive]); It will sort field1 and field3 ascending and field2 and field4 descending. best regards...
Hello everyone, I am still using 2.53f and I don't know if there has been any changes concerning dateformat. Anyhow here is my situation. When I change the...
Hi, You would probably need to use: DM.MT1.LoadFromDataSet(DM.Query1, [mtcpoStructure,mtcpoProperties]); This will also copy the displayformat from the query...
Hello Kim, No, unfortunately it has no effect. Hum...Well... It's probably simple, but I can't put my finger on it. Regards Pierre Demers "Kim Madsen"...
Hello Kim, Found the problem. This was a case of stupidity. A serie of events mislead me... Forgot to format a few fields in my reports that were corresponding...
For example i have some kbmmemtable table with one field (int type). It contains the following data: 1 2 _ _ 3 _ 4 Where '_' is null (not assigned value) When...
Hi, I don't know If it is a feature or not. But I had Turkish sort problem. As Kim adviced, I wrote my own sort algorithm in the CompareFields event of ...
Hello Kim, I have MT with 2 fields: TitleNo: TIntegerField Item: TStringField Index is on TitleNo Now I append 2 records with a DBGrid (manually): with the...
Hello Kim, Dont know if this is a bug or anomalie. Anyway I wants to report it. I had MT with index on a field named 'Title' (TInteger field). While...
Hello Kim, It seems that FindKey returns true in a detail table even when it is on a reference where this key does not exists. Is this a bug or is this normal ...
Sorry I was to fast with previous mail. I tryed it in a new project and it is OK. As I messes a little with changes, I deleted all csv files and it is working...
Hello, I have it again. It seems after a certain amount of records is added to the tables. Or could it be some propertie I forget using master / detail ? rgds,...
Hi All, Has anyone had experience with using TChart and Memtable? The standard edition shipped with Delphi seems to require the use of the BDE ie a physical...
Hello again ;-) The problem is in the BinarySearch method. It is called when specific amount of records is there. If I add there at the end of the procedure: ...
... Mike, I have used the standard TChart component with TClientDataSet used effectively as a memory table. No tables on disk, the TClientDataSet was filled...
... This is normal. Null has no value, so sort algorithms do not know how to handle it. Always try to avoid nulls in tables - they are minefields for producing...
Few days ago i posted message this problem of sorting empty data field (empty data field always in top of table, independently of sort order). Answer please -...
Hi, Its not a bug. Generally you cannot depend on where null fields will be in a sort order. If you look at SQL databases they are all different in the way ...
Hi, Its not a bug. Generally you cannot depend on where null fields will be in a sort order. If you look at SQL databases they are all different in the way ...
... will be in a ... the way ... the ... field. ... result to ... Thanks for advice, but i have a problem. I wished I have done the way you told me, but event...
Newbie question (at least new to 2.53g). Was using 1.32 before and it was working fine, but I needed to upgrade and now my master/detail report does not work. ...
Please disregard my previous post. I finally got this to work. Just in case anyone is interested, here is what I did (after creating all necessary table fields...
Anybody know how write my sort algorithm for empty data field? Kim Madsen advice me write my own OnCompareFields, but event OnCompareFields does not call for...
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.
