>>Which somehow proves the point of the whole exercise: the proverb „if it can't be done three ways in Fox, it's not worth doing at all“ is also portable to Python, Q.E.D.
>
>Yupp, but the cursors in Python, JS, Java and other tools are so DUMB
>compared to vfp, where they even do SQL tricks...
Done so in Dabo, by Ed Leafe and Paul McNett... I felt I had to do only one optimization - build the seek() lists for your cursor on requery, not every time you have a .seek() call. IOW, instead of building an index on demand, build it on requery. Requires some planning ahead (or not, you just add the field's name into the list of indexables).
And their bizobjects can do joins on each other... Well, when foxers write something, it has to have the good stuff, right?