Query: Inner Join into a FoxPro table

[badscots]

Hello all,

I have a page that uploads a file to the server, it then creates a table as part of a FoxPro DBC, imports the uploaded file and then will do the following:

Query="Select " & NFileName & ".postcode FROM lpcode INNER JOIN " & NFileName & " on "
Query=Query & "ALLTRIM(" & NFileName & ".postcode)==ALLTRIM(lpcode.postcode) into table "
Query=Query & "RESULTS DATABASE POSTCODE_LOOKUPS"

It seems to do the query, but not create the table???

Can anyone shed some light on this?

TXs Ian

 

[Chopstik]

Not very familiar with FoxPro, but sounds like your question might be better directed on that forum. Try forum184.

-----------------------------------------------------------------------------------------------------
"If you can't explain something to a six-year-old, you really don't understand it yourself."
-- Albert Einstein