>Is it possible to modify a table programmatically with the run-time version of VFP? I have an EXE out there and I need to add some fields to one of the the users table. Could I do this programmatically? For example, use the table, determine if the field already exists, and if not, add the field(s). Can this be done? Also, what happens to the database container behind the scenes? Will the runtime version of VFP also maintain the container? Same question for creating an index programmatically.
>
>Any help appreciated ... thanks in advance.
Hi Ernie,
What you could do is use the AFIELDS() function to get the current structure, modify the resulting array (adding fields, changing, etc.). Append in from the original table, then use COPY TO...to overwrite the original. I'd suggest that you use COPY FILE... to make a backup copy JIC.
hth,
George
Ubi caritas et amor, deus ibi est