Hi Steve, Did you ever get this to work? With Shape you can't have a null value for a numeric field (it would have to be zero) and I understand that a null text field is defined by having all space characters. Let me know if you still have problems and I'll put the question to our Shape experts.
Regards, Mark Mark Ireland, Product Support Engineer Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access > -----Original Message----- > From: Steve Nelson [mailto:[EMAIL PROTECTED] > Sent: March 17, 2005 10:44 AM > To: [email protected] > Subject: [fme] Setting NULL value to Shape file records > > > > > I know this should be an easy thing to do.... > > But I'm using the Attribute Setter to try and set certain > records to NULL, but when I load in the output shapefile to > ArcMap and try to select those records with a "SELECT * FROM > output WHERE value IS NULL", I don't get any records selected. > > I've tried setting the Value in the AttributeSetter to "", to > &NULL, and just leaving it blank. But the selection process > in ArcMap still won't select NULL values. > > In fact, when I leave the Value blank in FME, then ArcMap > sees this as a space or ''. > When I set it to &NULL, ArcMap sees it as ''. > When I set it to "", ArcMap still sees it as ''. > > There must be a way to set these values to a true NULL value > so that my select statement above will work??? > Can anyone tell me what I'm missing? > > Thanks very much, > > Steve > > > > > > > > > Get the maximum benefit from your FME, FME Objects, or > SpatialDirect via our Professional Services team. Visit > www.safe.com/services for details. > Yahoo! Groups Links > > > > > > > > Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
