mcode1="use mydatabase;alter table customer ADD email_add VARCHAR(45);" ?sqlexec(mscon,mcode1,'resultcur')>I'm using VFP with MySQL database.
>C:\Program Files\MySQL\MySQL Server 5.1\bin\ >mysql -umydata -pmypassword >use mydatabase; >alter table customer ADD email_add VARCHAR(45); >>
>lcOldDir=Fullpath(Curdir()) >CD "C:\Program Files\MySQL\MySQL Server 5.1\bin\" >mcode1="use mydatabase;" >mcode2="alter table customer ADD email_add VARCHAR(45);" >RUN mysql -umydata -pmypassword -e %mcode1% >cd (lcOldDir) >>