Hi basede on my worke with Oracle sql and fme try this
if you use a where clause just put whats in the where clause in the sql - in your case TIMEPOINT='TP' if you have a " in the string you will have to escape it with a \ first - like TIMEPOINT=\"TP\" - if you dont the fme parser will remove the "" and thats is why you get an error try placing the whole where claues in "" - like "TIMEPOINT='TP'" or "TIMEPOINT=\"TP\"" have fun Peter >From: "Roland Martin" <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: [email protected] >Subject: Re: [fme] Am I thick? Can't get the Where clause parameter to work >in 2006GB >Date: Thu, 14 Jun 2007 11:03:06 +0100 > >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 >> >> >> _________________________________________________________________ Find dine dokumenter lettere med MSN Toolbar med Windows-pc-søgning - hent den gratis her: http://toolbar.msn.dk Live Earth 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/
