Thanks for the additional info. Does this SQL work properly if you run it from a SQL Server tool? Here's a post that can help you find out exactly what's going on:
Kevin McNeish Eight-Time .NET MVP VFP and iOS Author, Speaker & Trainer Oak Leaf Enterprises, Inc. Chief Architect, MM Framework http://www.oakleafsd.com