K
Karikalan Ram
Guest
As I am using OE 11.4 Sql server 2014, QueryHandle: REPOSITION-TO-ROWID (Arrayvariable) fails to navigate/reposition to desired record - i.e. using dynamic nested queries with outer-join. I've verified array elements has valid row-id values and no '?' or invalid row-id in array element to cause failure. Same code logic with identical data works fine when we use Progress DB whereas it fails in SQL DB. If we create new set of records in SQL db code works fine, reposition issue only occurs on existing records ? Hence I beleive issue with existing record's 'effectiveness' of rowids. However, I can fetch records using these rowid individually. Is there anyway to rebuild/recreate rowids for exising records in SQL DB? Any suggestions to identify root cause reason pls? - Thanks.
Continue reading...
Continue reading...