Any suggestions?
If you can change the file struct, i will be probably going by adding a
'Meter' field, and calculate it via a trigger update (won't' be very hard).

Then all you have to do is convert your feet/inches lenght at program, and
do the SQL on the sigle resulting field. the selection will be much easier.

You can still retain the Feet/inches field for dispaly purpose, but use the
other one for calculate.

Conversion is just a statement, after all....


Nicola Brion
Tech Fossil (Often called a Dinosaur) - ancient animal that make things to

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].