Ernie,

I use code like this to update table structures:

open database TheDatabase
set database to TheDatabase
use TheTable
if ( type( "TheTable.aNewField" ) == "U" )
alter table ...
endif
use

>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.