sybase trigger is not properly displayed

If I use

sp_help trg

go

I get exactly the same output on both databases.

It is very weird that Oracle SQL Developers cannot generate the text in the expected order.

Please assist me to debug the statement passwed to the database, maybe it is a driver issue.

If I look in the dictionary, I see the mess boils done to the lines not being properly sorted. Is an order by missing in your statement?

sp_helptrigger trg

go

    create trigger trg

    on t1

    for insert, update

    as

    begin

       insert t2(id) select i.id from inserted i

    end

select colid, text from syscomments c, sysobjects o where o.id=c.id and o.name='trg';

    colid text

    ----- -------------------------------------------------------

    2     serted i end

    1     create trigger trg on t1 for insert, update as begin insert t2(id) select i.id from in

select colid, text from syscomments c, sysobjects o where o.id=c.id and o.name='trg' order by colid;

    colid text

    ----- -------------------------------------------------------

    1     create trigger trg on t1 for insert, update as begin insert t2(id) select i.id from in

    2     serted i end

Would you kindly post the SQL statement you are using for selecting trigger text from sybase?

Thanks a lot

This probably boils down to an ORDER BY.

Not fixed in 4.1EA2

in the long term maybe :-)

[edit]

but more probably migrate the operating system...

possibly the dictionary is not 100% clean, very old stuff

[/edit]