Hi Tracy Looked at all the tables in the queries folder. None of these were part of a DBC.
Then I noticed that there was something wrong with "membrenewal.dbf" in the command window. It was spelt "membrenewal .dbf" Removed the space before the . and now it showed in the connection wizard "Select Database and Table dialogue. On selecting and saving the odc file everything worked. Thank you Peter -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tracy Pearson Sent: 21 October 2010 16:45 To: [email protected] Subject: RE: Database connection wizard does not show foxpro table Peter Hart wrote on 2010-10-19: > Hi Folks > > > > Test connection succeed > > Click Ok and it asks to select he table to connect to but membrenewal > is not there but other query results are shown > Peter, When you created the table, are you sure it's not part of a database? If you have VFP IDE handy, opening the table and pulling the databases dropdown on the standard toolbar will show it quickly enough. Otherwise, look at using ADatabases() after opening the table. Tracy Pearson PowerChurch Software [excessive quoting removed by server] _______________________________________________ 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/a57fa4cf19531343a2ee11b57db8e3af100...@server.peterhartcomputers.local ** 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.
