>USE atable22 excl&& it works >If type('atable22.ccc')<>'U' > alter table atable22 drop column ccc > brow >ENDIF >****************************** >USE JUSTSTEM(thisform.text1.Value) excl&&& not works >If type('thisform.text1.Value.ccc')<>'U' > alter table (thisform.text1.Value) drop column ccc > brow >endif >
cTable=alltrim(thisform.text1.Value) Use (cTable) in 0 again alias tmp1 If Type('tmp1.ccc')<>'U' Alter Table tmp1 Drop Column ccc Endif Use in tmp1