Matt Slay wrote on 2010-11-16: > I have a FoxPro question I was hoping you could help me with. > > I'm using ADO.NET to query FoxPro tables. I'm trying to join two tables > that are in different folders. Here is the query I'm trying to run. > > SELECT fca.id_num AS [Id Number], CAST(fca.sequence * 6 AS VARCHAR) + ' > MONTH' AS [Description], fca.datesent AS [Sent To Cati], fcm.fudate AS > [Received From Cati] FROM > \\MyServer\g$\filestosurveyunit\followup\followup_sent_to_cati_all AS > fca LEFT OUTER JOIN > \\MyServer\g$\filesfromsurveyunit\followup\followup_from_cati_main AS > fcm ON fca.id_num = fcm.ident WHERE fca.id_num = ? > > > I keep getting this error though. > > > System.InvalidOperationException: Fill: SelectCommand.Connection > property has not been initialized. at
Matt, The VFPOleDB requires the path to be connected. I've not tried it recently, but I vaguely recall I could reach into subdirectories. If this isn't possible, you may be able to use the MS Shape provider to access two different paths to get the data. Tracy Pearson PowerChurch Software _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000a01cb85ba$228e8d50$67aba7...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
