Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locate Nearest Data
Message
 
 
To
16/04/2008 23:34:17
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP1
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01311354
Message ID:
01311357
Views:
15
What is your defenition of 'nearest' in this case?

>
>Table1 has only one field as
>
>code c(7)
>
>data in table as
>
>1
>11
>1101
>1101001
>1101002
>1101005
>1101025
>1101048
>
>If m.var1=1101045 then
>How to findout nearest value against m.var1
>
>I need answer 1101025
>
>Please help
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform