General information
Category:
Coding, syntax & commands
I agree, but I wouldn´t use STR(whatever,10) always with "10", but I´d use the appropriate width: for example, STR(Int1,5)+STR(Int2,8)+STR(Real1,10,2)...
>You can use STR() to convert each integer to a string, then concatante them together: INDEX ON STR(Int1,10)+STR(Int2,10)+...
>
>Of course, you'll have to do the conversions again each time you need to do a SEEK. You may want to try LOCATE and see if you really need the extra performance that SEEK offers.
>
>>Hi All,
>>
>>Ok, I've got a link table that links two, two part primary keys, together. And sense Seek is faster than locate, I need to index on the four part key. How do you build an index on four integers?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only