Hi all



I'm using Visual Foxpro 6 as my database backend and want to give the user 

the option to add fields into tables.



I've got strsql="Alter table mytable add column mycolumn c(1);"



When this runs it tells me the file is in use but having spent several 

hours tracing the code and putting in response.writes everywhere I don't 

think it is.



Do I need to do anything with pessimistic/file locking to get this to work?



Any help would be gratefully received.



Regards

Graham Brown

Is the syntax correct on the SQL ? Can you run the SQL in your DB 

directly ?