Re: MIDRANGE-L Digest, Vol 11, Issue 787

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

On 2012-05-18, at 3:43 PM, midrange-l-request@xxxxxxxxxxxx wrote:

>   Many releases ago I had concluded that was a restriction... although 
> I almost always had to re-encounter the SQL0312 to remind myself; I tend 
> to rely on a short-name to make my SQL statements more compact when 
> composed for sharing.  And although there was no change in the function...
>
>   Eventually in the v6r1 CREATE TRIGGER documentation came:
> Start of change>>All transition variable names are column names of the 
> subject table. System column names of the subject table cannot be used 
> as transition variable names.<<End of change


Thanks Chuck - that is the bit we missed.

Does seem a really strange restriction - you can do most everything else with either name. Weird.

Thanks again.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com