Search results

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...