set it to a floating type number and set the fieldmask property for the table in code or the object inspector (double click the table object, then double click the field and it's in the properties for the field. Set the mask as you would a mask in TMaskEdit.
That TMS AdvGrid has lots of undocumented "issues". I found their entire product line to be like that. You're best bet is to download all the samples for that component from their web site and hope that what you want is addressed in one of them because the documentation is more or less useless. Dave --- On Sat, 1/10/09, pietro <[email protected]> wrote: From: pietro <[email protected]> Subject: [advanced_delphi] DBGrid ... make me crazy ! To: [email protected] Date: Saturday, January 10, 2009, 12:16 PM Hi All, I am writing my first ADO / dBase program and I have problem with data inside a DBGrid: (data are from an MS Access table and I use Delphi-7 enterprise) I have a field where I would like to represent a frequency (let say a number), example 900.00 or 1034.23, so always with two decimal position after the integer part. - If I use the field as a string, all seem ok, but when sorting I have (from top-to bottom): 1024.67 - 3345.99 - 558.00 - 900.00 etc..., the sorting is on first character of the number (1-2-3-4-5-6-7-8-9), so there is no correlation with the "numerical value" ... from the smaller number to the biggest number (in effect I want to have: 558.00 - 900.00 - 1024.67 - 3345.99, etc...) - If I use the field as number, I can achieve the correct sorting sequence (smaller - to - biggest number) but number with two zero on decimal part will only represented with integer part: 990.00 = 990 Is there a way to solve my problem ??? I try also to use a TMS DBadvGrid (that's very beautiful and nice), but to activate the sorting I must set PageMode = false, then clicking on a DBgrid row, I don't know how to select a record to edit, it's always pointing to the last record of the table. Pleaseeeeeeeeee help !! TNX, Pietro ------------------------------------ Yahoo! Groups Links
