Hi!
VFP often have bad time to run such commands with ';'. In VFP7 there is ExecScript() function. For earlier versions just use StrToFile(MyVar,'temp.prg') after surrounding command by function definition, COMPILE (It is available in run-time executable starting from VFP6 SP6), then call it as a function.
HTH.
>Following is the value of the memo field. I need to execute this but when i try to execute this after taking it into a variable i got an error message. I have executed this script after copying it into the prg. Please give me some another solution if available. Thanks in advance.
>
>
>SELECT X.cid, ;
> X.cprojno AS XProjectNo, ;
> X.cunitnum, ;
> X.cseqno, ;
>X.ctentno AS XSSNo, ;
>X.clstname AS XLastName, ;
> X.cfstname AS XFirstName, ;
> X.captno AS XAptNo, ;
>X.caddline1, ;
>X.caddline2, ;
>X.ccity, ;
> X.ccounty, ;
>X.ccontno, ;
> X.cmailadd, ;
> X.cmailaptno, ;
> X.cmailcity, ;
> X.cmailstate, ;
> X.cmailzip, ;
> X.cphone, ;
> X.cprogtype, ;
>X.clrstatus, ;
> X.cs8status, ;
> X.dappln, ;
> X.deviction, ;
> X.dlastexam, ;
> X.dmovein, ;
> X.dmoveout, ;
> X.dreexam, ;
>X.drenteff, ;
> X.cmailadd2, ;
> X.mxml, ;
> Y.csocseqno, ;
>Y.calienid AS YAlienId, ;
> Y.ccitizstat AS YCitizenStatus, ;
> Y.cethnicity, ;
>Y.cfstname, ;
>Y.clstname, ;
> Y.cmidinit, ;
> Y.cminority, ;
> Y.cnation, ;
>Y.crelation AS YRelation, ;
> Y.csex, ;
> Y.cstate, ;
> Y.ddtbirth AS YDateofBirth, ;
>Y.ldisabled, ;
> Y.lelderly, ;
>Y.lhandicap AS YHandicap, ;
>Y.nassetamt, ;
>Y.nassetincc, ;
>Y.nbenamt, ;
>Y.nccareamt, ;
>Y.nearnasst, ;
>Y.nhcassist, ;
>Y.nincded, ;
> Y.nincexcl, ;
>Y.nmcareamt, ;
>Y.notheramt, ;
> Y.ntotexp, ;
> Y.ntotinc, ;
> Y.ntotwages, ;
>Y.nwlfamt, ;
>Y.coccupdesc, ;
>Y.cablework, ;
>Y.nschoolid ;
> FROM x, y Where Y.cXId = X.cid
>
>
>Deepak.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.