Hello all,
I am building an application that allows useres to define their own tables, load those tables with data from any number of types of sources and begin working with them. Some of the fields within the table structure seem to be off limits unless the table is part of a database structure, i.e. captions and comments being the most notable. Anyway, this is the appearance. I'm looking for a way around this. What I am considering is the following:
Once the new table structure has been defined and 'Create table' executed, use Afields to load the structure information into an array. Manipulate the 'off limits' field contents and then save that as a memory variable '.mem' with the same name as the table. Now I can have the information for building screens and reports available programatically to other programs within the system by loading the array using 'restore from additive'.
My questions here are; have I misinterptreted something in Visual Fox and/or is there an easier way that I have just missed.
Thanks,
Bill
I am building an application that allows useres to define their own tables, load those tables with data from any number of types of sources and begin working with them. Some of the fields within the table structure seem to be off limits unless the table is part of a database structure, i.e. captions and comments being the most notable. Anyway, this is the appearance. I'm looking for a way around this. What I am considering is the following:
Once the new table structure has been defined and 'Create table' executed, use Afields to load the structure information into an array. Manipulate the 'off limits' field contents and then save that as a memory variable '.mem' with the same name as the table. Now I can have the information for building screens and reports available programatically to other programs within the system by loading the array using 'restore from additive'.
My questions here are; have I misinterptreted something in Visual Fox and/or is there an easier way that I have just missed.
Thanks,
Bill