The database at my client is 9.1e SP 4. They are running Workgroup server, Dataserver for SQL and 4 brokers for ODBC SQL access. In the past we occasionally ran into this error. We restarted the database and everything was ok. But since a few weeks this error occurs more frequent as in 3 times a...
Thanks for your replies sofar. My 4GL skills and SQL skills are not too bad, but this is pretty specific stuff.
To resolve this issue I was looking for 2 stored procedures on the SQL side. The first would create a header record and assign as PK the last used number + 1. This new number needs to...
Hi Tom, I can tell you that the plans are really happening en excuting as we write. In 2 other sites of this company this migration is taking place right now and in 1 of them Progress is extensively used.
The current situation at this stage is that I do exactly what you proposed. Get last number...
Hello Tamhas,
I totally agree with you on that, but here is my situation: I am working from windows mobile devices via ODBC and I have to work with that.
Besides that, the company that is using this will be phasing out Progress in favor of SQLserver in the coming 2-3 years.
At this time the...
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...
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.