When SET Destination is a Logic Field
The destination field is set to blank, 1 (yes), or 0 (no), based on the value of the source field.
Source logic
The source field is copied directly to the destination field.
Source alpha
If the value of the first position of the source field is 0, N, or n, the destination field is set to a value of 0 (no). If the value of the first position of the source field is blank, the destination field is set to a value of blank. Otherwise, the destination field is set to a value of 1 (yes).
Source number
If the source field is null, the destination field is set to blank. Otherwise the destination field is set to 0 (no) if the source field is equal to 0, or 1 (yes) if the source field is not equal to 0.
Source date
If the source field is null, the destination field is set to blank. If the source field is a Gregorian binary date and has a value of 0, the destination field is set to 0 (no). Otherwise, the destination field is set to a value of 1 (yes).
|