Re: Retrieving trigger bodies from USER_TRIGGERS

Andrew Babb wrote:
>
> Dan,
>
> You are missing the
>
> set long 20000
>
> You will still need the arraysize and maxdata as well.
>
> Because the text of the trigger is stored in a long column, this defaults
> to 80 bytes, and hence you are only getting the initial portion of the
> text.
>
> Andrew

[original request snipped]

Thanks all. Typically something obvious!! SET LONG has done the trick.

--
Dan Hopkins Received on Wed Apr 21 1999 - 11:11:36 CDT