André Ficken
New Member
This is a question for Progress 9.1e SQL.
This is what I need to get done through an ODBC connection to a Progress 9.1e database.
- insert a record into a mastertable with the highest transaction number + 1 (eg. MAX(trans) + 1)
- feed the transnumber back into the calling program.
- insert a record into a detailtable with the same transaction number but starting on MAX(line) + 1
- feed linenumber back into the calling program too.
I have had a look at triggers/stored procedures and a bunch of variations of the INSERT INTO but after a full day of trying, I have not been able to resolve this challenge yet...
Anyone who could help me out here, or in the right direction?? You help is much appreciated!!!
Thanks!!
This is what I need to get done through an ODBC connection to a Progress 9.1e database.
- insert a record into a mastertable with the highest transaction number + 1 (eg. MAX(trans) + 1)
- feed the transnumber back into the calling program.
- insert a record into a detailtable with the same transaction number but starting on MAX(line) + 1
- feed linenumber back into the calling program too.
I have had a look at triggers/stored procedures and a bunch of variations of the INSERT INTO but after a full day of trying, I have not been able to resolve this challenge yet...
Anyone who could help me out here, or in the right direction?? You help is much appreciated!!!
Thanks!!