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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/advanced_delphi/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/advanced_delphi/join (Yahoo! ID required) <*> To change settings via email: mailto:advanced_delphi-dig...@yahoogroups.com mailto:advanced_delphi-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: advanced_delphi-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/