Hello Everyone, I am getting an error in an Active Link that says,
"ARERR [552] Failure during SQL operation to the database : ORA-01406: fetched column value was truncated." This happens during a Set Fields operation where it is reading a value from another form. The Set Field is very similar to a dozen others that work, and it was working till just now. I ran an SQL log, and the SQL statement is ":SELECT T570.C1,C2,C561000203,C8 FROM T570 WHERE ((T570.C561000214 != 'PIQ00120') AND (T570.C1 != 'ITRS0003037') AND (T570.C561000257 != 'Cancelled')) ORDER BY 1 DESC" followed by the same error message. But I can paste that very same SQL statement into TOAD, and it brings back a result set. I tried the Support Knowledge base, but the one entry referred to retrieving an attachment and the other to flashboards. Any idea what is going on? (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University Dwayne Martin Computing Support James Madison University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
