>Can you do select in VFP into a temp table and than feed it to MapInfo?

Sergey

HA HA! Would that I could. I originally wanted to drive MapInfo from VFP, via "Integrated Mapping", but the docn., examples, and expertise in this were very thin on the ground, and I couldn't get a toe-hold into it (doing it from VB was better docu'd). Hence, ALL the querying of maps is done from within a MapBasic app., which is invoked from VFP. Once inside this (when the query is generated, by the user clicking on a zone on the map), we're totally under the auspices of MB/MI. There's no way I can predict which data will go into the view in VFP.

:-(

I originally approached this problem WITH my knowledge of SQL but MB SQL is hopelessly inadequate. Jobs I can do with one SQL statement in VFP often require creating a table and do loops, etc.: reams of code (for instance it can't get more than 2 "look-up" descriptions into the cursor, via the main table's FKs)

Terry