RowID Error

This is NOT a standard Progress error message - I suspect it is generated by some framework you are using ...

Unless you reveal what framework you are using I doubt that someone might be able to help you.

Heavy Regards, RealHeavyDude.
 
I think there are 2 duplicate row ids. Thats why it is showing that error.
Do u have any idea on how to find duplicate row ID ?
 
From the database point of view there are no duplicate ROWIDs. If there were the database would be corrupt. I am just guessing the query is used to populate TEMP-TABLES and these TEMP-TABLES do have unique indexes defined on a field where either the ROWID of the database record or a TEMP-TABLE record is stored and then, caused by the OUTER-JOIN in your query, the same record occurs more than once in the result of your query.

Again, that's is just a guess!

Heavy Regards, RealHeavyDude.
 
actually i don;'t know how outer join works. So it is bit dificult for me 2 find above data. Can u simplify above query with simple syntax or can we opne dyanamic query with multiples tables to check above sysntax as outer-join works only with query.
 
Don't get mad at me, but: Without knowing what OUTER-JOINS are, how are you supposed to find the root of your issue? How are you supposed to write efficient queries at all?

Don't get me wrong: Yes you can do all this with a dynamic query but you don't need to. You can test this with a static query also - that way the compiler will tell you whether it is syntactically correct or not. If you want us to assist you more it would be helpful to post the actual code so that we don't need to magically extract it from an image.

The best advice I have for you is taking a Progress training.

Heavy Regards, RealHeavyDude.
 
You must log in or register to reply here.
Back
Top