Afternoon everyone, I'm trying to do a pre-select on a PGDB non-spatial table. The table is DETAIL and the column I'm interested in, named TIMEPOINT, is type TEXT and according to ArcCatalog table properties, this column "allows NULL values". I want to extract only those records that have a TP. This TIMEPOINT field contains either TP or nothing.
So, my "Where Clause" parameter on my SourceDataSet has been set to each of the following possibilities with no records being pushed through to be processed (I realize I've tried calls that shouldn't work, but just trying to get something to work or at least let some subset of data through): select * from DETAIL where TIMEPOINT = TP select * from DETAIL where TIMEPOINT = "TP" select * from DETAIL where TIMEPOINT = 'TP' select * from DETAIL where TIMEPOINT IS NOT NULL select * from DETAIL where TIMEPOINT <> "" What the heck am I doing wrong? Right now I'm reading all 1.5 million records and then using an AttributeFilter to only pass the TP records along - not the most efficient process. Any thoughts? Thanks all, Steve For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Love FME? Then open your diary to March 6-7, 2008 and write this... "Second Worldwide FME User Conference - Must Attend!" See http://www.safe.com/company/fmeuc2008/index.php for more details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
