>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
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.