The topic at the September 11 meeting of Chicago FUDG will be "MetaTables Using XML: Tables Within Tables" presented by Chicago's own Michael Hogan.
Data changes: fields required for different types of records may differ. When different records within the same table require one-to-one joins with different child tables or when a table gets bloated with mostly unused fields, it's time to consider a more efficient way of handling the supplemental data.
XML to the rescue! Using VFP’s CursorToXML and on-the-fly cursor structures you can encapsulate that data in memo and varchar fields. You'll learn how to:
* Avoid table bloat from rarely-used fields in tables
* Save and extract phantom sub-tables from memo and varchar fields
* Use different sub-table structures for different record types
* Use Memo to Object and Memo to Cursor techniques and their corollaries
* Choose When to use or not use this technique
Michael Hogan is an independent VFP consultant, and runs Ideate, LLC to provide business solutions in the Chicago area. His primary tools are Visual FoxPro and Web Connection.
Same time and place. Tues, Sept 11th. 5:30 pm. 53 W Jackson Blvd, Suite 826.
Dues are due. And bring a fin for pizza. We'll also have a report from the Fox Forward Conference in Atlanta. See ya then.
More info and upcoming meetings at
http://www.ChicagoFUDG.comFuture speakers include Whil Hentzen, Toni Feltman, and a CFUDG members night.
Randy Bosma
VFP - Because life is too short to code in something else...