Bill, Thx. Nice lookup. Didn't find any problems. I'm kind of wondering if there is a misplaced comma or something in the unload file.
Jan -----Original Message----- From: Bill Downall <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 13 Feb 2015 12:59:23 -0500 Subject: [RBASE-L] - Re: Finding error maybe: where (float(ctxt(doublecolumn)) is null and doublecolumn is not null ? On Fri, Feb 13, 2015 at 12:37 PM, jan johansen <[email protected] [mailto:[email protected]]> wrote: Group, Because the most recent update really needs your database to do a complete unload and reload, I've come across a couple of problems (stress these are problems with my data). During the reload I receive numerous errors of ONE specific problem, COLUMN mycolumnname must be valid DOUBLE. Fine. Then I search the column and fix the data and unload again. I've searched on that column looking for stuff like a text or something but not really seeing a problem. How would I query the database looking for an invalid value in that column? Jan
