Linda,
>I need to create a routine that allows the user to select a table that gets read, processed and uploaded to a web server. The table is an export from another system, which is written in Visual FoxPro. I was thinking about using FoxPro tables. I want to use the Mere Mortals business model but I'm not sure exactly how to set up the config files and business objects to accommodate a file structure that is always the same but has a name that continually changes. Is this something that is better handled by XML?
You can easily change the table name to be retrieved by adding a property to your business object. If you are using dynamic SQL, you can reference this property and dynamically build your SELECT statements. For example:
string Command = "SELECT * FROM " + this.TableName;
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com