Please run this query to solve the problem
update document set status='A' where accession_number='898';
On 02/22/2012 11:16 AM, pedroparkero [via NewGenLib] wrote:
select status from document where
accession_number='898';
returns '8'.
select * from cir_transaction where accession_number='898';
returns 3 rows, and is attached as csv: query.csv
-------------------------------------------------
With great knowledge comes great responsibility.
NewGenLib Open Source Support
Verus Solutions Private Limited
www.verussolutions.biz