Description Paul Hoffman 2011-11-09 15:48:05 EST

If a record or entity as more than one field with the @ID annotation, CNTL-1 put parentheses around the list of fields.   The parentheses should not be there and get a red tag.

Here is an example of a statement created for delete mypayment from ds :


get myPayment from ds  using(myPayment.Payment_ID, myPayment.category) with
	   	#sql{
	   		select
	   			Payment_ID, category, rtrim(description), Amount, 
	   			Due_Date
	   		from Payment
	   		where
	   			Payment_ID = ?
	   				and category = ?
	   	};

Generated statement should be:

get myPayment from ds  using myPayment.Payment_ID, myPayment.category  with
	   	#sql{
	   		select
	   			Payment_ID, category, rtrim(description), Amount, 
	   			Due_Date
	   		from Payment
	   		where
	   			Payment_ID = ?
	   				and category = ?
	   	};