Mensaje
De
25/03/2000 07:54:03
a
24/03/2000 12:36:51
General information
Foro:
Visual FoxPro
Category:
Bases de datos, tablas, vistas, índices y SQL
Título:
Re: Order Problem.
Miscellaneous
ID de la conversación:
00349932
ID del mensaje:
00350362
Views:
30
>>INDEX ON (a * 10^order of magnitude of max value of B+1)+ b +...
>>
>>will result in a number adjusted for relative magnitude; the first has the advantage of being magnitude/precision independent at the cost of not working correctly when negative values are possibly an issue. With very large numbers, rounding inherent in floating point representations can step in and make things mis-sort since the decimal precision of a computation has limits as we've discuissed before.
>>
>>>Thanks
>
>If we were dealing with integers ( instead of numerics ) here, could we use BINTOC() to create the index and would it make it more compact/efficient?
>
BINTOC() would work; you want to expressly name a size for the BINTOC conversion, since a small initial value would result in too small a string, possible with the consequence of truncating large value keys and missorting.
>>
>>will result in a number adjusted for relative magnitude; the first has the advantage of being magnitude/precision independent at the cost of not working correctly when negative values are possibly an issue. With very large numbers, rounding inherent in floating point representations can step in and make things mis-sort since the decimal precision of a computation has limits as we've discuissed before.
>>
>>>Thanks
>
>If we were dealing with integers ( instead of numerics ) here, could we use BINTOC() to create the index and would it make it more compact/efficient?
>
BINTOC() would work; you want to expressly name a size for the BINTOC conversion, since a small initial value would result in too small a string, possible with the consequence of truncating large value keys and missorting.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater
NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC
The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater
NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC
The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys