You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

SQR help

5 replies [Last post]
Guest's picture
Guest

Hi ,
Can anybody pls tell me what's the difference between Let & Move in SQR ?

Thanks

Guest's picture
Guest (not verified)
Re: SQR help

With an example pls .

Nitin's picture
User offline. Last seen 5 years 43 weeks ago. Offline
Joined: 06/30/2008
Posts: 73
Re: SQR help

LET helps you to have expressions like LET num = num +2;
While MOVE overrides the value.

Thanks
Nitin

Guest's picture
Guest (not verified)
Re: SQR help

Thanks Nitin.

Lepa's picture
User offline. Last seen 2 years 20 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: SQR help

This question has been asked before - see the answer here http://www.compshack.com/forum/peoplesoft/peoplesoft-technical/differenc...

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

sweety's picture
sweety (not verified)
Re: SQR help

Both Let and Move are Assignment statements.
But the move command is used to copy data from one storage location to another.An edit mask may be used.This command is used only for assignment , no experssions can be formed.

let command is used to assign the value of a literal or variable, or the results of an expression, to a user-defined variable.An expression may be formed as a combination of operands, operators, and functions.

The move command is more efficient that the let command for assignment statements.