F
Fernando Souza
Guest
Yes, we do not allow you to use the RECID() function in the where clause to. The kbase mentioned in the previous post was provided for the case where you want to dump as many records as you can when you have some sort of damage to the db. The code as is relies on the current implementation of ROWIDS for OpenEdge dbs, but know that ROWID is an opaque type and we reserve the right to change its storage/format. With that said, using the sample code posted, you should be able to find the record passing the recid found in the _Lock table record as the first and second parameters, and passing the partition id found in the _lock table as the third parameter. The GetNextRowid() method should return the rowid value for that recid/partition combination, which you can then use in the WHERE clause.
Continue reading...
Continue reading...