I have a problem via SQL pass through. I am building a bunch of work tables on a SQL back-end via VFP, all if fine -- to a point. When I get to a certain point, I don't get the expected results I need.

I am basically doing a join of two tables (SQL-Syntax)...

select a.*, b.* 
   into mydatabase.dbo.temptable
   from a, b 
   where a.id1 = b.id1 
     and a.id2 = b.id2

If I issue this statement from within VFP, I dont get any records created in the result set, however, if I do this exact same command from within the SQL window, I get the correct 200,000 record set.

I have even gone to the point of issuing a begin transaction/end transaction around this and still missing the boat. I even added a "checkpoint" to force all unwritten pages to be processed by SQL server but no luck...

I am really stuck with this, any input???