mud2
07-07-2009, 05:59 PM
What have I done?
I use a query to sort (ascending) a non-indexed table of strings INTO a second table (called Owen) I then use strcomp() to compare the string one half the way down the sorted table with all the values in the table.
In some cases, the strcomp output indicates that some of the records in the table were not in ascending order!
Uncovered(?) while I was trying to explain wierd "Devide and Conquer) searches.
A simple example:
Sorted table: z1 Z2 z2 ZA Za zb zz..
Sorted with respect to z2:
-1 -1 0 -1 -1 1 1
Somebody try it!
Thanks!
I use a query to sort (ascending) a non-indexed table of strings INTO a second table (called Owen) I then use strcomp() to compare the string one half the way down the sorted table with all the values in the table.
In some cases, the strcomp output indicates that some of the records in the table were not in ascending order!
Uncovered(?) while I was trying to explain wierd "Devide and Conquer) searches.
A simple example:
Sorted table: z1 Z2 z2 ZA Za zb zz..
Sorted with respect to z2:
-1 -1 0 -1 -1 1 1
Somebody try it!
Thanks!