Hi all,
I'm having some issues with database triggers and sequences having migrated by DB to SQL. The sequences appear to in place but there's no records in the database when I look at the _seqt tables (on the SQL side) and I cannot get my triggers where assign a unique id on a CREATE (Progress side trigger) to fire. If I try using next-value the value stays at 0 as well. If I look at the Sequence table in the Schema holder the Sequences appear to have all the cycle, initial value values etc. but on the SQL side nothing. Have I missed something here ? Is there any easy way to load the data from the Progress Database to the SQL database for sequences ? When should I specify the -trig option against the SQL database or the Progress Schema holder.
Thanks in advance
Wayne Bettcher
I'm having some issues with database triggers and sequences having migrated by DB to SQL. The sequences appear to in place but there's no records in the database when I look at the _seqt tables (on the SQL side) and I cannot get my triggers where assign a unique id on a CREATE (Progress side trigger) to fire. If I try using next-value the value stays at 0 as well. If I look at the Sequence table in the Schema holder the Sequences appear to have all the cycle, initial value values etc. but on the SQL side nothing. Have I missed something here ? Is there any easy way to load the data from the Progress Database to the SQL database for sequences ? When should I specify the -trig option against the SQL database or the Progress Schema holder.
Thanks in advance
Wayne Bettcher