General information
Category:
Coding, syntax & commands
What the error message do you have? Probably ";" signs should be removed from your expression before macro substitution
Denis
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only