-it's good training to do things on SQL Servers where it might simpler to have one query. Also it is less XBase. :)
-shurely one can split it into commands (SELECT DISTINCT to temp; SELECT FROM temp with additional fields; remove temp). I do that for tests remove it wait for VFP to crash by to complex operations and put it back :)
-SELECT DISINCT is faster without the additionals
-at least it as more elegant to add the memo and the rest of the additionals after SELECT DISTINCT with a second SELECT then endless ALTER TABLE (if it works with cursors at all, I'm not shure about this)
>I'm sure that you can do it in one command, but in practice it's two separate operations for your computer. I believe your solution will be faster.
>
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]