Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 2 of 2 total |
string field sorting method |
Wed, Oct 5 2011 8:23 AM | Permanent Link |
Luis Conception Gonzalez | Hi!
I have a string field where customers can store product codes. This field is an alphanumeric field, so users can store numbers, characters or both. The problem is when customers try to store only numbers. Just numbers without leading zero. 'Visually' they think the table is not ordered because, for example, "100" is before "9". My application tries to offer a correlative code where possible: searching for the last record and +1 (for numbers) but this doesn't work if the last visible record is "9" but the real last number is "100". Ok. Although I have tried to explain them the cause of the 'problem', some of them are asking for a solution. So here are my questions... 1) Is it possible to change the sorting method? SOmething like Windows default sorting method for files, folders, etc... in Control Panel? 2) Is it possible to calculate the next available number without a massive While/Locate? I have thought a possible solution: when app can't suggest the correlative number (because it already exists), try to offer a 'A0001' type number, and all future codes will be correlative to that one. Do you thing it is a good idea? Thanks! Santy C. |
Wed, Oct 5 2011 8:32 AM | Permanent Link |
Raul Team Elevate | Santy C.
See this thread for some ideas: http://www.elevatesoft.com/forums?action=view&category=dbisam&id=dbisam_general&page=1&msg=54988 Raul |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |