Hi Steve, This is not proof of thickness.
See this here thread: http://finance.groups.yahoo.com/group/fme/message/13575 I suspect if you put in the WHERE clause the following: TIMEPOINT='TP' ... it would work - otherwise, there should be some handy suggestions in the thread above. Cheers, Roland. On 13/06/07, snelsons2006 <[EMAIL PROTECTED]> wrote:
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
