Hmmm... I can't use a trigger, I would break the current software that is using the database. I am working on some external software that expands the capabilities of Epicor's Vantage which is using Progress 9.1D.
When I insert into a particular table that has an sequential id on it, the id does not get inserted, so I need to make sure that this gets incremented appropriately.
I appologize here, I am a newbie with Progress. Can I setup a sequence without affecting any other processes that are going on? Or how do I find out if there already is a sequence set up for this table and column?
I am using the Merant ODBC driver to connect to Progress. Do I use the same assign statement? I have noticed that SQL insert statements do work to at least insert data into the database.
Then if u're working with sql ( on a progress db ) and not Progress as a language to make programs, u should check the db documentation about managing sequences.. i think there is surely something about that.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.