Hi Stephen, Edit your input file and delete the first row that has the columnnames in it. Or use Gateway and load starting at row 2.
Bernie Lis ----- Original Message ----- From: Stephen Markson To: RBASE-L Mailing List Sent: Monday, July 05, 2010 3:41 PM Subject: [RBASE-L] - RE: Error Message 2227 I get error 2227 when I do: R> LOAD TableName FROM FileName AS CSV The first row of FileName has column names in it and the first one is "OrderID", which is an integer Primary Key, so the error message is "Value for OrderID cannot be NULL (2227)". Regards, Stephen Markson 416 512 6950 ------------------------------------------------------------------------------ From: [email protected] [mailto:[email protected]] On Behalf Of Dee Georgeson Sent: June 30, 2010 6:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Error Message 2227 Thanks Kenny. I get this error periodically and it doesn't contain any helpful information. We trap and log error messages too and this one has plagued me many years and also made its way over when we upgraded. Dee From: [email protected] [mailto:[email protected]] On Behalf Of Kenny Camp Sent: Wednesday, June 30, 2010 3:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Error Message 2227 If my memory serves, I believe it is a generic error message that Rbase triggers when a rule is broken. RBase (I think) builds a custom message that it displays when this triggered. A long time ago, (6.5 I think) In one place in my code where I would occasionally trap this message in an error log, I set rules off and try again as a work around. It seemed to have fixed (worked around) the issue. Kenny From: [email protected] [mailto:[email protected]] On Behalf Of Dee Georgeson Sent: Wednesday, June 30, 2010 4:58 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Error Message Does anyone know what error message 2227 means? Dee Georgeson No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.830 / Virus Database: 271.1.1/2964 - Release Date: 06/30/10 02:36:00
