John I am using 5/15 build but I am not sure when this started, I have not played with this much in past versions. My vars are set to Varchar and even If I do Update form the R> I get the truncated error but I never get an error Tracing the EEP.
Marc From: John Engwer Sent: Thursday, June 25, 2009 12:49 PM To: RBASE-L Mailing List Subject: [RBASE-L] - 2570 "data will be truncated" caused by improper SET VAR data type This is a FYI in case you see the 2570 error appear after upgrading to the latest build. You may have done something dumb, like me. I have an invoice in one of my vertical applications that has a variable (varchar) vRETURN_POLICY as one of the objects. When I originally designed the report, years ago, the return policy variable was a note data type. When I updated my application to the 5/15 build of V8 the invoice report started posting an error 2570 "data will be truncated" . I tried tracing the section of code that printed the report but the trace would not post the error in single step mode. It would post the error message if I pressed F5 but trace would not point to the line of code that was causing the error. After many hours, I discovered that when I set my VAR vRETURN_POLICY to null prior to printing the report, I was setting it to a note data type rather than a varchar. My defective SET VAR command had been running error free until I upgraded to the 5/15 build. If you start getting 2570 "data will be truncated" errors after updating to build 5/15, this will give you one possible cause. I changed the SET VAR from note to varchar and the error went away. John
