RE: If Statement Evaluates for Both True & False

Jaz

Hi, 

 

I  was wondering why in the following if statement both parts of the statement are executed when I run the script? It somehow evaluates the statement to both true and false. 

For (k = 1, k <= N Rows(dx), k++,
	Current Data Table (dt); 
	q = k-1;   
	For Each Row(
		If(dt:colAutomatically <= colManuallyEnd[k] & dt:colAutomatically >= colManuallyStart[k], dt:newInstructionsColumn = colInstructions[k], print("No")); 
	); 
);

If true it should execute the following line: 

dt:newInstructionsColumn = colInstructions[k]

If false it should execute the following line: 

print("No")

Any help would be appreciated. 

txnelson

Try using this code to check out what is going on

For( k = 1, k <= N Rows( dx ), k++,
	Current Data Table( dt );
	q = k - 1;
	For Each Row(
		If( dt:colAutomatically <= colManuallyEnd[k] & dt:colAutomatically >= colManuallyStart[k],
			dt:newInstructionsColumn = colInstructions[k];
			Print( "\!nYes ", Row(), " ", dt:newInstructionsColumn[Row()] );
		,
			Print( "\!nNo ", Row() )
		)
	);
);