L
Lars Neumeier
Guest
[quote user="Peter Judge"] > The whole ROWID thing from Progress is something to generally avoid, or use on an extremely short-term basis. Agree wholeheartedly on this. One place where I know that TT ROWID values change is when data is passed across an AppServer boundary. You should only ever be using ROWID to do local, in-same-session-only lookups or for db lookups and even there I’d suggest looking for alternatives - table partitioning means that the DB ROWID can change. [/quote] The help for the ROWID function states: •If you want a called procedure to use the same record as a calling procedure, use the ROWID function to ensure that you are retrieving the same record. Use a SHARED ROWID variable or procedure parameter to communicate the ROWID of a record from one procedure to another. The second procedure can then find the same record. This is an alternative to using shared buffers or buffer parameters. Your post and this help entry is a little bit confusing.
Continue reading...
Continue reading...