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.

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